Home » SQL & PL/SQL » SQL & PL/SQL » DELETE PARENT CHILD DATA
DELETE PARENT CHILD DATA [message #2471] Thu, 18 July 2002 11:10 Go to next message
pappu
Messages: 5
Registered: July 2002
Junior Member
I am looking for the trigger by which I can delete the parent and child data at the same time.

Report message to a moderator

Re: DELETE PARENT CHILD DATA [message #2491 is a reply to message #2471] Fri, 19 July 2002 10:41 Go to previous message
ctg
Messages: 146
Registered: July 2002
Senior Member
if you want to delete the child along with the parent, have the foreign key set to DELETE ON CASCADE. Then you do not have to maintain a trigger. but you better be careful.

Report message to a moderator

Previous Topic: Retrieving an entire table row for row?
Next Topic: Re: to_date from character field yyyymmdd
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 20:13:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.