In this blog post, let’s learn about the error message “1044 Constraint constraint-name could not be created because the referenced columns in the referenced table are not part of a unique constraint.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1044 Constraint constraint-name could not be created because the referenced columns in the referenced table are not part of a unique constraint.
Reason for the Error
The columns that constraint-name references in the referenced table are not part of a unique constraint.
Solution
Check that constraint-name references a unique or primary constraint in the referenced table
