I am trying to delete a record from one table in my db, but another table has references to this row (foreign keys). So I want to make on delete cascade using SQL Developer in Oracle 11g. How can I do this?
To answer the OP's technical question: In SQL Developer, you edit the (child) table with the foreign key reference. Select "Constraints" from the treeview on the left and then select the foreign key in question. In the "Referenced Constraint" form there is a drop down named "On Delete". From that drop down, choose "Cascade".
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With