In this blog post, let’s learn about the error message “1119 Dropping metadata object table-name is not allowed.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1119 Dropping metadata object table-name is not allowed.
Reason for the Error
You attempted to use the DROP TABLE statement to drop a table that is part of SQL/MX metadata.
Solution
Metadata tables can be dropped only by using the DROP SQL statement or the MXTOOL GOAWAY utility. Both methods will irrevocably destroy the database
