HPE NonStop SQL/MX Error – 1158 Object name already exists.

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