SQL Server Extended Properties: Stairway to Exploring Database Metadata Level 7

Question

Post reply

SQL Server Extended Properties: Stairway to Exploring Database Metadata Level 7

Phil Factor

SSC-Insane

Points: 20244
More actions
February 14, 2017 at 11:54 am

#401621

Comments posted to this topic are about the item SQL Server Extended Properties: Stairway to Exploring Database Metadata Level 7
Best wishes,
Phil Factor

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

SQLOzzie Default port Points: 1442 More actions · Answer 1

Phil,

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.

Thanks,
Ozzie

Phil Factor SSC-Insane Points: 20244 More actions · Answer 2

TNT Screen capture. It is really useful for articles like this.

Best wishes,
Phil Factor

Brandon Forest SSCommitted Points: 1977 More actions · Answer 3

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.

Brandon Forest

Senior SQL DBA

Purple Communications, LLC

Phil Factor SSC-Insane Points: 20244 More actions · Answer 4

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.

Best wishes,
Phil Factor

Conrad Muller SSC Veteran Points: 294 More actions · Answer 5

https://www.databasezone.com/techdocs/dbscripts.html

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.