[hmssiri]

How can I check whether there are hidden tables in SQL Database, using Enterprise Manager

[Trogdor]

In the SQL Query Analyzer you can view the systemtables, is that what you mean ?

[hmssiri]

Trogdor, on 6 Oct, 2009 - 06:03 AM, said:

In the SQL Query Analyzer you can view the systemtables, is that what you mean ?

Thanks for the reply.

I had a problem with Hard disk. However I could get the copy of that. and It was running SQL server for ATTENDANCE Databse. With that copy I could locate the tables except one table which I am unware of the table name. I used the Enterprise Manager.

may I know, there is a method to hide table?. So How can I locate that hidden tables? using Enterprise manager. (I know how to hide system tables)

I want to make sure the database copied correctly before formatting the hard disk.

[baavgai]

SQL Server has no facility to hide tables. If you're the administrator, then there's nothing you can't see.

In some cases, "system" tables will not show up in some contexts.

e.g. All the tables ( and views ) for database:

select * from information_schema.tables

To see everything, you can use sysobjects:

select * from sysobjects

-- limited to just user and system tables
select * from sysobjects where xtype in ('U','S')

-- pointed at a particular database on the server
select * from master..sysobjects where xtype in ('U','S')