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

  • Phil Factor

    SSC-Insane

    Points: 20064

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

    Best wishes,
    Phil Factor
    Simple Talk

  • SQLOzzie

    Ten Centuries

    Points: 1373

    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: 20064

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

    Best wishes,
    Phil Factor
    Simple Talk

  • Brandon Forest

    SSCommitted

    Points: 1814

    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: 20064

    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
    Simple Talk

  • Conrad Muller

    SSC Veteran

    Points: 294

    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.

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

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