Error Creating Table: "There is already an object named 'table' in the database", but I have no constraint with that name

Question

Error occur in MS SQL Server

Error Creating Table: "There is already an object named 'table' in the database", but I have no table and not any constraint with the same name in database.

I have to inform you that this happened after performing a rename on a table and then a creation of a table named with the old table name.

Example:

sp_rename OldTable, NewTable
Create Table [OLDTable] ([id] [int] Identity(1,1) NOT NULL)

And then it gives me the error

If someone knows the answer, I've been searching for hours and I would be glad to solve this problem.

Answer 1

Try SELECT * FROM sys.objects WHERE name LIKE '%yout_table_name%' to see all existing system objects with given name.