Previous Topic: -174 - UPDATE/DELETE CANNOT HAVE CORRELATED SUBQRYNext Topic: -176 - FOREIGN KEY <authid.constraintname> VALUE VIOLATION


-175 - FOREIGN KEY <authid.constraintname> REFERENCE VIOLATION

Explanation

You attempted to UPDATE/DELETE a Primary/Unique key referenced by the foreign key defined by the indicated constraint.

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

User Response

Change the search condition to exclude rows that include a foreign key reference or delete the foreign key references.