In this blog post, let’s learn about the error message “1052 Constraint cannot be dropped because it does not belong to the specified table.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1052 Constraint cannot be dropped because it does not belong to the specified table.
Reason for the Error
An ALTER TABLE statement with DROP CONSTRAINT specified a name that is not the name of a constraint on this table.
Solution
Either correct the table name or the constraint name and reissue the statement. You can use the SHOWDDL statement to display the names of constraints on the table
