ERROR: Foreign key columns ... do not match the primary key columns ...

Reason:

You attempted to create a foreign key constraint and the number or type of columns named in the constraint table do not match the number of type of columns in the referenced primary key constraint.

Resolution:

Ensure the foreign key constraint columns match the number and type of the columns in the referenced primary key constraint.

Tips:

  • Use the star$constraints view to find the definitions of primary key constraints.
Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk