Previous Topic: -175 - FOREIGN KEY <authid.constraintname> REFERENCE VIOLATIONNext Topic: -177 - PRIMARY/UNIQUE CONSTRAINT CANNOT BE DROPPED DUE TO REFERENCE


-176 - FOREIGN KEY <authid.constraintname> VALUE VIOLATION

Explanation

During an SQL INSERT or UPDATE, referential integrity was violated. A foreign key of the table did not have a corresponding row in the referenced table.

The SQLSTATE that equates to this SQL return code is 23503.

User Response

Modify the values of the foreign key columns that are being inserted or updated so that they match the referenced key, or add a row to the referenced tables that have the matching key values.