CODEWITHSUNDEEP
sqlsql-serverssms
thenoob
thenoob

Reputation: 83

SQL Server Magement Studio - View sysobjects table in Explorer

This seems simple enough, but can't see to find any information on it. All I want to is view the table definition for sysobjects in Object Explorer along with all of the other system tables. I know I can jus select * from sysobjects, but I want to see all of the other system table definitions as well in object explorer. When I open up system tables under my database, all I see is dbo.sysdiagrams. Help?

Upvotes: 8

Views: 10673

Answers (3)

marc_s
marc_s

Reputation: 755287

alt text

Scroll down quite a bit, and you should find the sys.sysobjects system catalog view and be able to select from it.

Upvotes: 7

JNK
JNK

Reputation: 65197

You may be able to get what you need from the sys.objects VIEW.

Under your DB go to Views-->System Views to see your options.

Upvotes: 14

Oded
Oded

Reputation: 499302

They should appear under the Database node, though they might be hidden.

Upvotes: 1

Related Questions