In this blog post, let’s learn about the error message “1055 Object object-name already exists.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1055 Object object-name already exists.
Reason for the Error
You attempted to create an object with a name that is already in use for a table, a view, or a stored procedure in this schema.
Solution
Verify that the object name is correct. If the name is not fully qualified, verify that the current schema is set correctly. You can choose a different name, or drop the existing object with this name and then reissue the statement
