Constraint....On Delete, On Update.

• nitrox

  SSC Veteran

  Points: 270

  More actions

  April 29, 2002 at 9:11 am

  #78662

  Hey all-

  Getting ready to try my hand at really using constraints. Anyone reason why I should not set the On Delete and the On Update to Cascade? This option just makes sense in my book...if I delete an instance in one table, it should get rid of them all. I could see setting these to No Action if you want to create a history of some type. Just a little nervous when it comes to the "delete" word.

  Thanks,

  Doug

• Antares686

  SSC Guru

  Points: 125444

  More actions

  April 30, 2002 at 5:21 am

  #428078

  PK to FK constraints are handle quite well with cascade but you should make sure to test the effects for you setup before you put in production.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)