Delete conflicted with the Reference

Question

Possible Duplicate:
I got error “The DELETE statement conflicted with the REFERENCE constraint”

I am receiving the error

The DELETE statement conflicted with the REFERENCE constraint fk

Is there away to automatically delete the row that is causing this reference conflict such as setting a property or such. To avoid first deleting the child and then going back and deleting the original row you wanted to delete?

You need to set the foreign key's delete option to CASCADE on delete — user710502, Mar 10 '12 at 23:25
SQL-Server: http://msdn.microsoft.com/en-us/library/ms186973.aspx and here(with SSMS): http://www.mssqltips.com/sqlservertip/2365/sql-server-foreign-key-update-and-delete-rules/ — Tim Schmelter, Mar 10 '12 at 23:26

score 0 · Answer 1 · answered Mar 10 '12 at 23:25

0

Turn on delete cascade to your table and the referencing row will be deleted automatically too.

answered Mar 10 '12 at 23:25

juergen d

201,996
37
293
362

score 0 · Accepted Answer · answered Mar 10 '12 at 23:26

0

When you create your table, specify ON DELETE CASCADE.

This sets up the delete action for the table to also delete referencing rows, if it is the parent.

See http://msdn.microsoft.com/en-us/library/ms174979.aspx.

answered Mar 10 '12 at 23:26

womp

115,835
26
236
269

score 0 · Answer 3 · answered Mar 10 '12 at 23:26

0

Delete the key to key table, the relation table first before deleting the original primary key record.

answered Mar 10 '12 at 23:26

iefpw

6,816
15
55
79

Delete conflicted with the Reference

3 Answers3