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 ...