Delete statement conflicted with COLUMN REFERENCE constraint

Junior Spellweaver
Joined
Feb 23, 2009
Messages
188
Reaction score
5
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.
 

Attachments

  • error - Delete statement conflicted with COLUMN REFERENCE constraint - RaGEZONE Forums
    error.webp
    20.3 KB · Views: 37
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??
 
Upvote 0
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)
 
Upvote 0
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. :grr:

BTW is the AID and the CID field in your db writable or not?
 

Attachments

  • screenshot - Delete statement conflicted with COLUMN REFERENCE constraint - RaGEZONE Forums
    screenshot.webp
    18.6 KB · Views: 24
Upvote 0
Back