Delete statement conflicted with COLUMN REFERENCE constraint

Results 1 to 5 of 5
  1. #1
    Proficient Member Blue_Blast is offline
    MemberRank
    Feb 2009 Join Date
    GermanyLocation
    196Posts

    Delete statement conflicted with COLUMN REFERENCE constraint

    Hi Guys
    I dunno how that happened, but when i try to delete 1 of my Accounts in the DB this error appears.
    I also recognized that the AID field and the CID field in dbo.Account and dbo.Character are write protected so I cant edit it...

    I know in the past I can just mark it and hit DEL and the Account was deleted, but with this error it's impossible...

    And when I try to laod my backup it's the same -_-

    Any solutions for this

    EDIT: Attached Screenshot of problem. The descrpition of the problem is in english BTW.
    Attached Thumbnails Attached Thumbnails error.jpg  


  2. #2
    Account Upgraded | Title Enabled! sayuta is offline
    MemberRank
    Jan 2007 Join Date
    The NetherlandsLocation
    205Posts

    Re: Delete statement conflicted with COLUMN REFERENCE constraint

    you deleted a column? o.o

  3. #3
    Proficient Member Blue_Blast is offline
    MemberRank
    Feb 2009 Join Date
    GermanyLocation
    196Posts

    Re: Delete statement conflicted with COLUMN REFERENCE constraint

    Hehe no^^
    I dun think so cuz in my Backup it's the same Prob.

    EDIT: Is the AID and CID Field in ur DB writable??

    EDIT2: Found this on google

    Error Message:

    Code:
    DELETE statement conflicted with COLUMN REFERENCE constraint Constraint Name.
    The conflict occurred in database Database Name, table Table Name, column Column Name.
    The statement has been terminated.
    Causes:

    This error occurs if you are trying to delete a record from a table that has a PRIMARY KEY and the record being deleted is being referenced as a FOREIGN KEY in another table.
    But how can I change this??

  4. #4
    Account Upgraded | Title Enabled! sayuta is offline
    MemberRank
    Jan 2007 Join Date
    The NetherlandsLocation
    205Posts

    Re: Delete statement conflicted with COLUMN REFERENCE constraint

    when u got a list of the column names, right click on the aid column and edit it

    then check what key u need.

    (No clue exactly how u do it)

  5. #5
    Proficient Member Blue_Blast is offline
    MemberRank
    Feb 2009 Join Date
    GermanyLocation
    196Posts

    Re: Delete statement conflicted with COLUMN REFERENCE constraint

    Mhh well I checked the Settings of my db and it seems like if there is only a PRIMARY Key listed
    But how is that error possible, when it's impossible to have an FOREIGN Key .
    Im rly confued right now.

    BTW is the AID and the CID field in your db writable or not?
    Attached Thumbnails Attached Thumbnails screenshot.jpg  



Advertisement