In this blog post, let’s learn about the error message “1049 Constraint cannot be dropped because it was specified to be NOT DROPPABLE.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1049 Constraint cannot be dropped because it was specified to be NOT DROPPABLE.
Reason for the Error
You attempted to drop a constraint that cannot be dropped.
Solution
None