Expand Your SQL Server 2005 Dictionary Using Extended Properties

Wednesday May 16th 2007 by DatabaseJournal.com Staff

Generate a data dictionary using SQL Server 2005 metadata then take it one step further. Use Extended Properties to add additional metadata that will explain why each data object is important to the application that uses it.

[From Developer.com]

There are a number of ways to obtain metadata in SQL Server 2005. Metadata, in the simplest terms, means data about data. Metadata is content that describes your application's data and potentially how that data is used. Metadata is useful in many ways. Software vendors rely extensively on metdata when building database tools. Application developers can utilize metadata for tasks such as constructing dynamic SQL statements. By combining metadata available in SQL Server system views with SQL Server Extended Properties, you can compile a rich data dictionary for all interested parties.

The article continues at http://www.developer.com/db/article.php/3677766

Mobile Site | Full Site