Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Posts
    9

    Unanswered: Cascade deletes in SQL Server 7.0?

    Is it possible to have data deleted(automaticly) from tables related to the one im deleting from..

    Example:

    Table A have a one to many relation to 6 other tables.

    I will delete a member from Table A, will the data conserning the member in the other 6 tables be automaticly removed?

    Best wishes.

    (If not, how should I write the sp to handle this task?)

  2. #2
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    For SQL Server 7.0 you would have to implement TRIGGERS to perform cascade deletes. However in SQL Server 2000 there is cascade deletes, defined by 'Cascading Referential Integrity Constraints'
    MCDBA

  3. #3
    Join Date
    Feb 2002
    Posts
    9
    Okay!

    Thanks for responding - Scre@m

Posting Permissions

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