HPE NonStop SQL/MX Error – 3067 ALTER TABLE ADD CONSTRAINT allows only DROPPABLE constraints.

In this blog post, let’s learn about the error message “3067 ALTER TABLE ADD CONSTRAINT allows only DROPPABLE constraints.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

3067 ALTER TABLE ADD CONSTRAINT allows only DROPPABLE constraints.

Reason for the Error

You specified an ALTER TABLE ADD CONSTRAINT statement with NOT DROPPABLE constraints. Only DROPPABLE constraints are allowed.

Solution

Correct the syntax and resubmit