SQL Server Magement Studio - View sysobjects table in Explorer

Question

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?

Answer 1

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.

Answer 2

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