CREATE TABLE T1(ID INT, CONSTRAINT PK1 PRIMARY KEY(ID));
> ok
CREATE TABLE T2(ID INT, F INT,
CONSTRAINT PK2 PRIMARY KEY(ID),
CONSTRAINT FK2 FOREIGN KEY(F) REFERENCES T1);
> ok
ALTER TABLE T2 DROP CONSTRAINT PK1;
> Constraint "PUBLIC.PK1" is used by constraint "PUBLIC.FK2"
ALTER TABLE T2 DROP CONSTRAINT PK1 CASCADE;
> ok
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/b9bf7e88-3287-44ef-b2e3-f1a767e96533%40googlegroups.com.
