I am working on a database design using the SQL Server Database Diagram tool. I created a table with the name dbo.Example and before defining any columns, attempted to save.
Got an error that SQL can't save a table without any columns and as I wanted to save the other work I had done before completing this table, I deleted it and saved successfully.
I then make many more changes and save the diagram. All is good.
UNTIL I am ready to correctly define my dbo.Example table and get the
'Table 'dbo.Example' already exists' error.
The table is not among the tables returned from
select name from sys.tables;
and does not appear in the Database->Tables GUI view.
I can't find where I need to clean up and drop this table.
Where does SQL Server keep the metadata about the database diagrams?