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

  • 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

  • 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

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

    Best wishes,
    Phil Factor
    Simple Talk

  • 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

  • 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

  • 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