System table mismatch

• SwedishOrr

  SSCrazy

  Points: 2955

  More actions

  September 24, 2010 at 11:35 am

  #227071

  Hi Folks,

  I've got a table that is showing up in sys.tables but does not actually exist. Is it safe to delete the record from sys.tables in this situation? I ran the following queries:

  SELECT [name],[object_id] FROM sys.tables WHERE [name] = 'table';

  name object_id

  ----- -----------

  table 194815756

  SELECT OBJECT_ID('table');

  (No column name)

  -----------------

  NULL

  SELECT OBJECT_NAME(194815756);

  (No column name)

  -----------------

  table

  DROP TABLE

  ;

  Cannot drop the table 'table', because it does not exist or you do not have permission.

  I'm a sysadmin so the permissions portion of that message doesn't apply. Does anyone have any ideas or recommendations? Also, does anyone know how something like this could happen?

  Thanks so much!

• SwedishOrr

  SSCrazy

  Points: 2955

  More actions

  September 24, 2010 at 11:40 am

  #1227153

  My sincere apologies for jumping the gun, the problem is that this table is not a part of the dbo schema and I had overlooked that.