Post reply

Modifying and deleting extended properties

  • March 28, 2011 at 10:56 pm

    #247921

    Comments posted to this topic are about the item Modifying and deleting extended properties

  • March 29, 2011 at 8:47 am

    #1304927

    Great article, Adam. I will save it in my briefcase for future reference.

    SQL DBA.

  • March 29, 2011 at 9:23 am

    #1304953

    Thanks Sanjay, I hope that the series proves useful.

    Adam

  • March 29, 2011 at 10:10 am

    #1304999

    Thanks for the article Adam. It is well thought out, and well presented and written. I have used a exists then update or add methodology. I've only ever added extended properties for databases, tables, and stored procedures because I encourage naming to be as self explanatory as possible. However, if the database schema was controlled by a third party, and/or the column names and paramter names were criptic then I could definitely see benefit to describing them with extended properties. One of the potential uses of extended properties is the ability to build a data dictionary which I am hoping you will have a script for in the next article of the series. I have a decent script for doing this in case you don't already have one built. It's not in my coding style so I didn't write it, and regretfully I don't have a comment at the top to give the author proper credit.

  • March 30, 2011 at 1:58 am

    #1305279

    Hi Toby,

    The next (and final) article does indeed contain scripts to document a data dictionary, using the database metadata - let me know if you like it once it appears.

    Regards,

    Adam

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

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