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
