HPE NonStop SQL/MX Error – 1026 Only the schema owner or super ID can drop a schema.

In this blog post, let’s learn about the error message “1026 Only the schema owner or super ID can drop a schema.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

1026 Only the schema owner or super ID can drop a schema.

Reason for the Error

An attempt was made to drop a schema by someone other than its owner or the super ID.

Solution

The owner of the schema (or super ID) must issue the DROP SCHEMA statement