Hi, I'm trying to give names to all the constraints I create, but for some reason, I can't change the name of the constraint for IDENTITY typed columns, example: DROP TABLE IF EXISTS SUPPLIERS; CREATE TABLE SUPPLIERS ( SUPPL_ID BIGINT IDENTITY(1,1), SUPPL_DESC VARCHAR(50) NOT NULL,
CONSTRAINT PK_SUPPLIERS PRIMARY KEY (SUPPL_ID), CONSTRAINT UK_SUPPLIERS_DESC UNIQUE (SUPPL_DESC) ); The UK_SUPPLIERS_DESC constraint was created, but the primary key constraint is called "CONSTRAINT_A". -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
