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

Asked By Gothman Paul 0 points N/A Posted on - 03/21/2017

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?

• Status: Open
• Question Views: 313
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Database
• Question Tags: database system | OS

Answered By Anthony Y Salazar 0 points N/A #291830

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

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.

About Anthony Y Salazar

Questions
2

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 03/21/2017
• Question Category: Database