Results 1 to 1 of 1
  1. #1
    Join Date
    May 2004

    Unanswered: SQL Server v7 and cascading deletes

    I can't believe that SQL Server 7 can't do cascading deletes, is it really true? I have two related tables, the functionality that I seek is that if the Primary Key gets deleted it also deletes all the matching Foreign Keys too. I mean for cryin out loud Access can do cascading deletes but I can't find any setting in SQL Server 7.

    I thought I would be able to accomplish this with a delete trigger but I'm getting a dependancy error before the trigger gets a chance to fire due to the relationship.
    Last edited by lcsgeek; 06-21-04 at 14:21.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts