HPE NonStop SQL/MX Error – 1614 Constraint constraintName could not be created as referencing column columnName is part of clustering key of table tableName.

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