Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
tsql:managing_extended_properties [2020/01/02 13:52]
admin [Extended properties]
tsql:managing_extended_properties [2020/01/02 14:00] (current)
admin [Batch modification]
Line 130: Line 130:
  
 ==== Batch modification ==== ==== Batch modification ====
-The script below makes no changes, but builds and returns two SP calls for every existing extended ​property:+The script below makes no changes, but builds and returns ​code for two SP calls based on existing extended ​properties:
   * a call to ''​sp_updateextendedproperty''​ which sets the property to its current value;   * a call to ''​sp_updateextendedproperty''​ which sets the property to its current value;
   * a call to ''​sp_dropextendedproperty''​ which drops the property.   * a call to ''​sp_dropextendedproperty''​ which drops the property.