question

Angel avatar image
Angel asked

Database Schema

How to identify the schema of the system databases resource,master,model, msdb&temp db in sql server 2005?
sqlsql server 2005
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Can you please clarify? Are you looking to find the schema of the system databases? I'm not sure I understand fully.
0 Likes 0 ·

1 Answer

· Write an Answer
Grant Fritchey avatar image
Grant Fritchey answered
Schema defines the tables, views, etc., of a database. Looking at the schema of system objects is basically the same as looking at the schema of non-system objects. You just have less control. You can see the system objects from within SQL Server Management Studio (SSMS) by clicking on the System databases, expanding the folders and selecting System under tables or stored procedures or whatever. You can also query the system objects directly, even use [sp_help][1] to get descriptions of the objects. [1]: https://msdn.microsoft.com/en-us/library/ms187335.aspx
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.