Post reply

on delete cascade

  • 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

  • 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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply