System tables in SQL Server

Tags:
Database
SQL 2005
SQL Server 2005
System tables
How to view System tables in drop down menu of a database in SQL SERVER 2005

Software/Hardware used:
SQL SERVER 2005 Express edition, OS-Windows XP professional SP2

Answer Wiki

Thanks. We'll let you know when a new response is added.

Using SQLServer Management Studio you will be able to see them under System Databases/msdb/tables/system tables

With SQL Server Enterprise Manager they are viewed under the msdb database tables

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Denny Cherry
    What drop down menu are you talking about? SQL Server doesn't have any sort of drop down menu with the list of tables in it that I can think of.
    67,505 pointsBadges:
    report
  • The Most-Watched IT Questions: July 5, 2011 - ITKE Community Blog
    [...] 2. Smf and Mrdenny have some general info on system tables in SQL Server. [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: