Toad World® Forums

Toad for Oracle v12.0.7 create table scripting constraints generated together instead of by themselves

It seems that the way toad for oracle generated a create table script from an existing table has changed. It seems that previous version created seperate statements for each constraint. now it seems it generates a single statement. Is there a switch that changed this behaviour ?

before:

ALTER TABLE my_schema.tabl1 ADD (
CONSTRAINT FK1
FOREIGN KEY (ID1)
REFERENCES my_schema.tabl2 (ID1)
ENABLE VALIDATE);

ALTER TABLE my_schema.tabl1 ADD (
CONSTRAINT FK2
FOREIGN KEY (ID1)
REFERENCES my_schema.tabl3 (ID2)
ON DELETE SET NULL );

now

ALTER TABLE my_schema.tabl1 ADD (
CONSTRAINT FK1
FOREIGN KEY (ID1)
REFERENCES my_schema.tabl2 (ID1)
ENABLE VALIDATE,
CONSTRAINT FK2
FOREIGN KEY (ID1)
REFERENCES my_schema.tabl3 (ID2)
ON DELETE SET NULL
);

Nevermind, just found the switch… doh…