A Compare is generating DDL to add a Primary Key to a table. The generated DDL is missing the unique constraint name.
ALTER TABLE creator.table
ADD PRIMARY KEY
(COL1
,COL2
);
The constraint name is missing.
The same issue occurs with a migration, the constraint name is not shown:
,PRIMARY KEY
(CON_ID
,COLLEGE_ID
)
Expect:
,CONSTRAINT CON_ID PRIMARY KEY
(CON_ID
,COLLEGE_ID
)
Release:
Component: RCM
Here is some detail regarding how constraints are generated in Migrator: