on delete cascade

• worldwithsmile2014

  SSC Veteran

  Points: 287

  More actions

  April 16, 2015 at 2:59 am

  #306982

  i work on visual stduio 2013 ,

  i have [highlight=#ffff11]Branches table [/highlight] contains

  ------------------------------

  BranchID primary Key

  //////////////////////////////////////////////////

  ClassTable contains

  ------------------------------

  ClassNum primary Key

  BranchID primary Key and foregin key reference (Branches table,BranchID)

  ////////////////////////////////////////////////////////////////////////////////

  when add (on delete cascade) to BranchId in ClassTable ,the update of table an error occured while the batch was being executing..

  is not allow delete row from Branches table when have rows related in ClassTable

  and also when delete row from Branches table ,the rows which related in ClassTable are not delete

  ******************************************************************************

  Thank you

• Phil Parkin

  SSC Guru

  Points: 246978

  More actions

  April 16, 2015 at 3:08 am

  #1791266

  Can you include the proper DDL, as generated in SSMS?

  Also, you have not asked a question, leaving us to guess.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel