In this blog post, let’s learn about the error message “1146 Object object-name could not be altered because it is not a object-type.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1146 Object object-name could not be altered because it is not a object-type.
Reason for the Error
The type of the object specified in the command is inconsistent with the DDL command being used. For example, this occurs if DROP TABLE is used, and the object you specify is an INDEX.
Solution
Check that the correct object name was specified and execute a statement that is consistent with that type of object
