In this blog post, let’s learn about the error message “1043 Constraint constraint-name already exists.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1043 Constraint constraint-name already exists.
Reason for the Error
You assigned the same constraint name to two constraints on the same table. Constraint names must be unique among all the constraints for a table.
Solution
Make all the constraint names for the table unique. Use SHOWDDL to see the names of existing constraints