Fix Issue The Delete Statement Conflicted With The Reference Constraint. Fast.

Asked By 0 points N/A Posted on -
qa-featured

I am working on SQL database system, but I am facing the problem that the delete statement conflicted with the reference constraint how can I get rid off from this fault?

SHARE
Answered By 0 points N/A #291830

Fix Issue The Delete Statement Conflicted With The Reference Constraint. Fast.

qa-featured

This bug come because you have the same data in the table that is a reference to the other table you are deleting.

Try to drop or again create the constraints. You can also neglect the information that Foreign Key reference.

You can drop the table and add the constraint again.

Also, check that you are deleting the record from the exact table you want to remove or in the correct order.

Always use cascading delete in your database. If you remove primary key, then the record will delete automatically.

Related Questions