Updating the tables using Snap Shots
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Updating the tables using Snap Shots

  1. #1
    Join Date
    May 2002
    Posts
    1

    Post

    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

  2. #2
    Join Date
    Feb 2001
    Posts
    100
    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
  •  


Click Here to Expand Forum to Full Width