DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Updating the tables using Snap Shots

  1. 05-14-2002, 10:52 AM #1
    nimishakav
    nimishakav is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 05-14-2002, 11:07 AM #2
    Hakimca
    Hakimca is offline Member
    Join Date
    Feb 2001
    Posts
    100
    Hi,

    Use ON DELETE CASCADE clause when defining your foreign key

    Nour
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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