How to find which foreign key constraint fails
Posted by:
jmf
Date: May 03, 2005 07:51AM
Hello,
When trying to delete a record, I get this error message : "1217: Cannot delete or update a parent row: a foreign key constraint fails".
Since many fields from many tables are in relation with the id field of this table, it is hard to find where the error comes from.
Is there a way to create a map of the foreign key constraints for a database ?
Thanks.
Subject
Views
Written By
Posted
How to find which foreign key constraint fails
4237
May 03, 2005 07:51AM
2354
May 13, 2005 05:01AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.