HPE NonStop SQL/MX Error – 1135 Clustering key column column-name must be assigned a NOT NULL NOT DROPPABLE constraint.

In this blog post, let’s learn about the error message “1135 Clustering key column column-name must be assigned a NOT NULL NOT DROPPABLE constraint.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1135 Clustering key column column-name must be assigned a NOT NULL NOT DROPPABLE constraint.

Reason for the Error

You attempted to make a column that is not NOT NULL NOT DROPPABLE a part of the clustering key of a table.

Solution

Specify that the column-name is NOT NULL NOT DROPPABLE and resubmit