Search code examples
sqlsql-serverconstraintssql-delete

SQL error when trying to delete a row from my table

I have an issue and get this SQL error that I can't identify the source of. It's blocking the delete API and nothing is clear about it on the internet:

The DELETE statement conflicted with the REFERENCE constraint "FK_re". The conflict occurred in database "test", table "dbo.MatchingTable", column 'M_Id'.

The statement has been terminated. The DELETE statement conflicted with the REFERENCE constraint "FK_re". The conflict occurred in database "test", table "dbo.MatchingTable", column 'M_Id'.

Solution

  • The DELETE statement conflicted with the REFERENCE constraint "FK_re"

    this means you can't delete what you want to because there is a foreign key reference.

    The tables are linked by a piece of data in certain column, and SQL is warning you that if you do that the link will be to nothing.

    This is one of the strengths of SQL data integrity.