Manage Extended Property

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

 Rate this |   Join the discussion |  Briefcase

     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: 30 | Views in the last 30 days: 1