February 24, 2009 at 5:49 am
Hi all,
I have two table master and child. if i delete data from master table. but that data exist in child table. i want delete data from child first then master allow to delete that data.
Thanks in advance
February 24, 2009 at 7:41 am
You need a foreign key on the child table with ON DELETE CASCADE.
February 24, 2009 at 8:36 am
Do you want the process to be automatic, which is what setting a Foreign Key to ON DELETE CASCADE will do or do you want to control it?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply