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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 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.
    66,010 pointsBadges:
    report
  • VendoorMohankrishna
    [...] 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following