HPE NonStop SQL/MX Error – 1187 The schema name schema-name is reserved for SQL/MX metadata.

In this blog post, let’s learn about the error message “1187 The schema name schema-name is reserved for SQL/MX metadata.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1187 The schema name schema-name is reserved for SQL/MX metadata.

Reason for the Error

NonStop SQL/MX reserves certain schema names for its own use.

Solution

See the SQL/MX Reference Manual for reserved schema names. Choose a name that is not reserved and reissue the CREATE statement