Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How can I make on delete cascade using SQL Developer in Oracle 11g?

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?

like image 717
palAlaa Avatar asked Dec 30 '25 11:12

palAlaa


1 Answers

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".

like image 177
samneric Avatar answered Jan 01 '26 13:01

samneric



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!