Disable Foreign Key Constraints

[Nathan Poorman]

Is there any way to select a group of tables and then disable/enable their constraints via the PL/SQL GUI? We'd like to be able to do this without having to write DDL scripts to toggle the constraints.

 

[Marco Kalter]

If you open the constraint folders for each table, you can multi-select them (Ctrl-left-click) and select "Disable" or "Enable" from the popup menu.

There is no "Disable all constraints" option for a table though.