Tip: Maintaining a Data Dictionary

Query Analyzer provides a simple but relatively unknown mechanism for working with properties.

Brian Moran

October 23, 2001

1 Min Read
ITPro Today logo in a gray background | ITPro Today

Extended properties are a great way to store business and technical definitions for tables and columns if you need to create a data dictionary for your database. However, extended properties aren't especially helpful if you don't have an easy way to add new properties and edit their definitions. Query Analyzer provides a simple but relatively unknown mechanism for working with properties.

In Figure A, I created a property called MS_Description on the au_id column of the authors table. Figure B shows how to edit this value through Query Analyzer in a few easy steps:

  1. Open Query Analyzer and launch the Object Browser.

  2. Navigate to the au_id column of the authors table.

  3. Right-click the au_id column and select Extended properties.

A simple dialog box lets you create new extended properties or edit existing ones.

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like