Error: The @newname value ‘test’ is already in use as a OBJECT name and would cause a duplicate that is not permitted. (Microsoft SQL Server, Error: 15335)

ERROR MESAGGE:

“Error: The @newname value ‘test’ is already in use as a OBJECT name and would cause a duplicate that is not permitted. (Microsoft SQL Server, Error: 15335)”

DESCRIPTION:

When you try to change the name of an existing object (such as “table” or “view” …), if you already have another object with that name, you will get this error message.

SOLUTION:

If you want to create the object with the same names, then you must use different “Schema” objects for these objects.