Wednesday, March 21, 2012

Data Dictionary

Hi,
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

A data dictionary is a set of metadata that contains definitions and representations of data elements. Within the context of a DBMS, a data dictionary is a read-only set of tables and views. The data dictionary is database in its own dictionary. Amongst other things, a data dictionary holds the following information:

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