In this blog post, let’s learn about the error message “1046 Referenced and referencing column lists do not match for constraint constraint-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1046 Referenced and referencing column lists do not match for constraint constraint-name.
Reason for the Error
The list of referencing columns in constraint-name does not match the list of unique key columns that it is referencing.
Solution
Verify that the constraint-name list of referencing columns matches the list of referenced columns
