Previous Topic: -171 - THE REFERENCED TABLE DOES NOT CONTAIN A PRIMARY KEYNext Topic: -173 - THE REFERENCING AND REFERENCED COLUMNS ARE NOT EQUIVALENT


-172 - THE NUMBER OF REFERENCING AND REFERENCED COLUMNS DOES NOT MATCH

Explanation

During a CREATE or ALTER TABLE, you attempted to define a foreign key reference, but the number of referencing columns was not equal to the number of referenced columns.

The SQLSTATE that equates to this SQL return code is 42S10.

User Response

Modify the lists so that they contain the same number of columns.