Results 1 to 2 of 2

Thread: When should I use Cascade Update / Delete???

  1. Jul 31st, 2002, 08:29 AM #1
    jesus4u
    jesus4u is offline

    Thread Starter
    PowerPoster
    Join Date
    Jan 2001
    Location
    Florida
    Posts
    3,216

    Question When should I use Cascade Update / Delete???

    Can anyone explain this to me for SQL 2000?

    Thanks
    Reply With Quote Reply With Quote
  2. Aug 1st, 2002, 04:13 AM #2
    Bill Crawley
    Bill Crawley is offline
    Fanatic Member
    Join Date
    Feb 2000
    Location
    Dunmow,Essex,England
    Posts
    898
    it's the same as in any other database. When you have a table reliant on another table then you can use the cascade method which should ensure database integrity.

    Typical example might be an order header table with an order line table. If you delete the order header, then cascade delete on orderline would make sense, since you dont want the lines to exist without a header.
    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