Home » SQL & PL/SQL » SQL & PL/SQL » on delete cascade  () 1 Vote
on delete cascade [message #271123] Sat, 29 September 2007 12:26 Go to next message
Messages: 48
Registered: September 2007
can anyone help me to get alter table sql code which makes the foreign key row of that table to be null if the referenced row of the parent table is deleted?
If i dont mention on delete cascade during create table command,will data base automatically prevent the deletion of referenced row?

Thanks for the help

Re: on delete cascade [message #271125 is a reply to message #271123] Sat, 29 September 2007 12:40 Go to previous message
Michel Cadot
Messages: 63923
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"on delete set null".

Previous Topic: Bulk Fetch Through Multiple Tables
Next Topic: Need help in table
Goto Forum:

Current Time: Tue Oct 25 19:35:35 CDT 2016

Total time taken to generate the page: 0.06478 seconds