In this blog post, let’s learn about the error message “3050 The constraint must have the same catalog and schema as 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
3050 The constraint must have the same catalog and schema as the specified table.
Reason for the Error
You specified a constraint whose catalog and schema do not match the specified table.
Solution
Correct the syntax so that the constraint and table have the same catalog and schema
