doubts on "On delete Cascade" of sql server 2000?

• raghuldrag

  Hall of Fame

  Points: 3160

  More actions

  January 7, 2014 at 11:41 pm

  #284246

  Hi Friends,

  I found The word alter table "ON DELETE CASCADE" what is use on it? explain me and tell some real scenarios.

  Thanks & Regards

  A.Rama Krishnan

• Andrew G

  SSChampion

  Points: 12809

  More actions

  January 8, 2014 at 12:51 am

  #1678325

  When you create a foreign key constraint, you can specify ON DELETE CASCADE (or UPDATE). This means that if any row is deleted in the parent (referenced) table, the delete will also occur for any records which contain that key in the child (foreign key) table.

  Examples here http://www.mssqltips.com/sqlservertip/2743/using-delete-cascade-option-for-foreign-keys/