开发者

SQL Server Magement Studio - View sysobjects table in Explorer

开发者 https://www.devze.com 2023-01-23 21:29 出处:网络
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 c

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

精彩评论

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

关注公众号