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
RyjuRaju
Messages: 48
Registered: September 2007
Member
Hi
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

Ryju
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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
"on delete set null".

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


Current Time: Mon Feb 17 19:02:14 CST 2025