In this blog post, let’s learn about the error message “1094 Object object-name could not be dropped because it is not of type object-type.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1094 Object object-name could not be dropped because it is not of type object-type.
Reason for the Error
A DROP TABLE specified an object that is not a base table, or a DROP VIEW specified an object that is not a view, or a DROP PROCEDURE specified an object that is not a procedure.
Solution
Reissue the DROP statement with the correct combination of specified object type and actual object type