-
Hi
I have Master tables in my database.I want to update those master tables by using snap shots 24 hours time.Here I have an issue.If any record got deleted in the snap shot,that entry also need to be deleted in my master table.But there is a Primary Key-Foreign Key relation ship has been established between Master and Child tables.How do I go about this.
Thanks & Regards
Srinivas Nimishakavi
-
Hi,
Use ON DELETE CASCADE clause when defining your foreign key
Nour
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|