HPE NonStop SQL/MX Error – 1236 The schema name specified for SQL object object-name is not valid. The schema name must be the same as the schema being created.

In this blog post, let’s learn about the error message “1236 The schema name specified for SQL object object-name is not valid. The schema name must be the same as the schema being created.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1236 The schema name specified for SQL object object-name is not valid. The schema name must be the same as the schema being created.

Reason for the Error

You specified a schema name for an object that is different from the name of the schema being created.

Solution

Specify a schema name for the object that matches the name of the schema being created