In this blog post, let’s learn about the error message “1040 The use of ALTER on metdata tables is not permitted.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1040 The use of ALTER on metdata tables is not permitted.
Reason for the Error
An ALTER TABLE statement was issued naming a table that is part of the SQL/MX metadata. Such tables cannot be altered.
Solution
None
