New Transact SQL Video Tutorial: Extended Properties in SQL Server 2000 - What They Are and How to Use Them to Generate Your Data Dictionary

Extended Properties in SQL Server 2000 - What They Are and How to Use Them to Generate Your Data Dictionary - view details

Extended Properties are available for tables, columns, stored procedures - actually, they're available for all objects in SQL Server. In many systems, good database design goes hand in hand with good documentation and that means that you'll need a good data dictionary. Extended Properties allow you to add descriptions, traits, and anything else you'd like to your objects. These are query-able, updateable, and very handy in describing difficult column relationships, keys, etc.

• Category: Commonly Used T-SQL Constructs: Datatypes, Type Conversion, Variables, System Functions and Views and more
• Skill Level: 300 (Intermediate)
• Length: 9:40 (6.30MB)
• Applies to Versions: SQL Server 2000
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

Note: You must have the TSCC codec installed to view this video