Comments posted to this topic are about the item SQL Server Extended Properties: Stairway to Exploring Database Metadata Level 7
What utility do you use to get those cool cutouts of the SQL code?
Great article - I stole a few chunks for my own data dictionary.
TNT Screen capture. It is really useful for articles like this.
I use Extended Properties on any new table DDL, and important existing tables, to describe both the purpose of the table and the purpose of the column. When this is done properly, it becomes a data dictionary that is easily accessed with TSQL.
Senior SQL DBA
Purple Communications, LLC
It makes a lot of sense. Once a team realises the advantages, they rarely go back to the old ways. I'm currently working on a PowerShell script that takes a conventional table script with block and inline comments and turns it into extended properties relating to the correct table object.
I have written a set of T-SQL scripts to help me design, document, and maintain SQL Server databases, and now I’d like to share them.
Viewing 6 posts - 1 through 5 (of 5 total)