I Prefer Jim Developer James Schubert shares his code and his thoughts.

T-SQL Multi-Table Delete

I was trying to run a DELETE query on multiple tables and I kept getting this error:

The DELETE statement conflicted with the REFERENCE constraint

I'm not that great with SQL, but I can get by. DELETEs have always been somethng that have given me trouble. So, I thought I'd share this simple fix.

DELETE FROM PRODUCT
FROM BOOK
WHERE BOOK.ID = PRODUCT.BOOK_ID
AND BOOK.ID = @BOOK_ID

You just have to make sure you put the table with the FK as the first table in the query.

I guess I should have paid a little more attention in Database class. We learned Oracle, which is different from Microsoft's SQL in many ways.