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 def开发者_C百科initions as well in object explorer. When I open up system tables under my database, all I see is dbo.sysdiagrams. Help?
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.
Scroll down quite a bit, and you should find the sys.sysobjects
system catalog view and be able to select from it.
They should appear under the Database node, though they might be hidden.
精彩评论