开发者

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.


SQL Server Magement Studio - View sysobjects table in Explorer

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜