New answers tagged sql-server-express
Whether using dbo or not, always specify the schema prefix explicitly. Otherwise, if you have users with different default schemas, you could end up with objects in a schema you didn't expect. One user creates a table in one schema, and the other can't see it. Here is a quick example: CREATE SCHEMA floob AUTHORIZATION dbo; GO CREATE USER blat1 WITHOUT ...
You should check the default schema of the user through which you are deleting the table. The table existing should be in another schema and the table being deleted is in the default schema of the user.
Top 50 recent answers are included