Previous Topic: -172 - THE NUMBER OF REFERENCING AND REFERENCED COLUMNS DOES NOT MATCHNext Topic: -174 - UPDATE/DELETE CANNOT HAVE CORRELATED SUBQRY


-173 - THE REFERENCING AND REFERENCED COLUMNS ARE NOT EQUIVALENT

Explanation

During a CREATE or ALTER TABLE, you attempted to define a foreign key reference, but the referenced columns and the referencing columns were not equivalent in type, length, and/or scale.

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

User Response

Modify the foreign key reference definition, or modify the columns to match.