In this blog post, let’s learn about the error message “1027 The definition schema definition-schema-name is dropped when its catalog is dropped.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1027 The definition schema definition-schema-name is dropped when its catalog is dropped.
Reason for the Error
You attempted to drop the schema containing the metadata tables for the catalog.
Solution
Use DROP SCHEMA statements to drop all the user-created schemas in the catalog. Then use the DROP CATALOG statement to drop the catalog. The schema definition-schema-name is dropped when you drop its catalog
