ALTER CONSTRAINT UNIQUE

14 views
Skip to first unread message

Pylou Ej

unread,
Jan 19, 2021, 7:17:43 AM1/19/21
to H2 Database
Hello I want to add a constraint on a column but when I send the SQL command the BDD adds _INDEX_3 to the end of the name... How do we stop this?
Query:
ALTER TABLE GS_PAYS ADD CONSTRAINT GS_PAYS_UN1_1 UNIQUE (GS_PAYS_LIB);
Result:
GS_PAYS_UN1_1_INDEX_3

Pylou Ej

unread,
Jan 19, 2021, 8:45:47 AM1/19/21
to H2 Database
Close.
Reply all
Reply to author
Forward
0 new messages