Is there anything analogous to a "data dicitionary" tool that is bundled with SQL Server 2005? Something that could be used to store and manage enterprise data meta-data.
Thanks,
JR
The system tables and views...following:
Data dictionary
From Wikipedia, the free encyclopedia
Precise definition of data elements Usernames, roles and privileges Schema objects Integrity constraints Stored procedures and triggers General database structure Space allocations|||Hi,Thanks for the info. May I assume that these system tables and their contents are officially documented somewhere? Any pointers to any such docs would be greatly appreciated.
Regards,
JR
|||
In Object Explorer in SQL Server Management Studio, look under Databases/System Databases/master/Views. Master contains server level information. Similarly Databases/System Databases/msdb/Views | Tables has server level information for SQL Agent, Database Mail, Log Shipping and other technologies.
Each user database also has system views.
With the exception of a few internal views and tables each view or table has a topic in Books Online.
|||True most of the information pertaining to the components & objects of SQL Server are documented in Books online, there are few bits and pieces that are not documented in BOL where you can find information by searching them on web.
No comments:
Post a Comment