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: 65079
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: Thu Jul 20 11:29:48 CDT 2017

Total time taken to generate the page: 0.09927 seconds