In this blog post, let’s learn about the error message “1022 Schema schema-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
1022 Schema schema-name already exists.
Reason for the Error
You attempted to create a schema in a catalog with an existing schema name.
Solution
If you did not use a fully qualified name, check that the default generates the correct catalog name. Retry the request, specifying a schema that does not already exist
