Sql Enterprise Manager

hidden tables in SQL Database

Page 1 of 1

3 Replies - 1899 Views - Last Post: 07 October 2009 - 06:17 AM Rate Topic: -----

#1 hmssiri  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 6
  • Joined: 05-September 09

Sql Enterprise Manager

Post icon  Posted 04 October 2009 - 03:25 AM

How can I check whether there are hidden tables in SQL Database, using Enterprise Manager
Is This A Good Question/Topic? 0
  • +

Replies To: Sql Enterprise Manager

#2 Trogdor  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 15
  • View blog
  • Posts: 627
  • Joined: 06-October 06

Re: Sql Enterprise Manager

Posted 06 October 2009 - 07:03 AM

In the SQL Query Analyzer you can view the systemtables, is that what you mean ?
Was This Post Helpful? 0
  • +
  • -

#3 hmssiri  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 6
  • Joined: 05-September 09

Re: Sql Enterprise Manager

Posted 06 October 2009 - 08:02 PM

View PostTrogdor, 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.
Was This Post Helpful? 0
  • +
  • -

#4 baavgai  Icon User is offline

  • Dreaming Coder
  • member icon

Reputation: 5796
  • View blog
  • Posts: 12,631
  • Joined: 16-October 07

Re: Sql Enterprise Manager

Posted 07 October 2009 - 06:17 AM

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')


Was This Post Helpful? 1
  • +
  • -

Page 1 of 1