In this blog post, let’s learn about the error message “1613 Constraint constraintName could not be created as it conflicts with constraintName.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1613 Constraint constraintName could not be created as it conflicts with constraintName.
Reason for the Error
You attempted to create a column list of referential integrity constraint, which matches the column list of another referential integrity constraint in the table. However, the referential action differs for these two constraints.
Solution
None