Table that won't go - even though it exists?

[CInman]

I have a table in a SQL 7 d/b that, although shows under the Tables branch in Enterprise Manager, I am unable to delete, rename, view, etc. I cannot do anything with it, as it claims it is not a member of the tables collection - so something has clearly "corrupted" but I need to know "where" all references to a table could exist, so I can manually remove it - can anyone help?

 

[tlbroadbent]

Before attempting to mannually delete records, run

DBCC Checkdb

to see if the corruption can be corrected. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[Guest_imported]

Thanks Terry, appreciated. I'll give it a go.

 

[CInman]

Thanks Terry, much appreciated.

 

[cutiger93]

I have seen this and it seems as if Enterprise Manager is still showing the table when it does not exist.

If Terry's solution does not solve the problem.
I would do the following:

select * from sysobjects where name like '%tablename%' to see if the table exists.

If it exist I would try to delete it with the following:
drop table tablename

If it does not exist I have had to stop and start the SQL Server to get rid of it from Enterprise Manager.

 

[CInman]

That makes sense ... I'll review and feedback, thanks for your thoughts and time - much appreciated.

 

[tlbroadbent]

If the problem is only in Enterprise Manager, you can try to refresh. Right-click the database and select refresh. If that doesn't work (from my experience it doesn't work very often) then disconnect from the Server and reconnect or stop and restart EM. You shouldn't have to restart SQL Server in this case. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.