In this blog post, let’s learn about the error message “1050 Constraint cannot be dropped because it is used as a referenced object for a foreign key.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1050 Constraint cannot be dropped because it is used as a referenced object for a foreign key.
Reason for the Error
You attempted to drop a unique or primary constraint, with dependent referential constraints, using the RESTRICT option, which does not remove such constraints.
Solution
If you want to drop the dependent referential constraints, use the CASCADE option for the DROP CONSTRAINT command
