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.