In this blog post, let’s learn about the error message “1614 Constraint constraintName could not be created as referencing column columnName is part of clustering key of table tableName.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1614 Constraint constraintName could not be created as referencing column columnName is part of clustering key of table tableName.
Reason for the Error
You attempted to create a referential integrity constraint with a referencing column that is a part of the clustering key of the referencing table.
Solution
None
