Cannot drop the table <tablename> because it does not exist in the system catalog.

The DROP TABLE command removes a table from the specified database. The specified table cannot be removed because it does not exist in the system catalog.

To correct this error

  1. Check to see if you have typed the table name correctly.

    -or-

  2. Determine if you have sufficient access permission to drop the specified table. DROP TABLE permissions default to the table owner.

    -or-

  3. Ask your database administrator to investigate the problem.

See Also

Other Resources

Permissions and Visual Database Tools (Visual Database Tools)
Working with Tables in Table Designer (Visual Database Tools)
DROP TABLE (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance