SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Manage Extended Property

By lxya,

     While we are exploring the possibility to build data-driven application whose GUI are all dynamically generated according to database objects' extended property, we find the system provided procedures: sp_addextendedproperty, sp_dropextendedproperty,sp_updateextendedproperty can add extended property to only one object each time, while fn_listextendedproperty can not let you search objects to display their extended property.

so I wrote a stored procedure which can let us manage extended property more efficiently.
      The procedure will first build an affected db object list by querying system catalog tables using the pattern specified by the passed in parameters and then call corresponding system procedures for all objects in the list.

Total article views: 453 | Views in the last 30 days: 1
Related Articles

Industrial-strength database documentation using Extended Properties

To finish this short series on extended properties a look at documenting sets of database objects


Modifying and deleting extended properties

Continuing the short series on extended properties, this article explains how to turbocharge the cre...


Extended Properties Introduction

Part one of a four part series intent on demystifying and making more accessible SQL Server extended...


Extracting Extended Properties

In this second article of a short series we look at using the Extended Properties which you have add...