In this blog post, let’s learn about the error message “1158 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
1158 Object name already exists.
Reason for the Error
You specified a create of synonym name on an object, but an object of that name already exists.
Solution
Correct the syntax so that the correct name is used