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
