Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
tsql:managing_extended_properties [2020/01/02 14:00]
admin [Batch modification]
tsql:managing_extended_properties [2020/06/16 13:47] (current)
admin
Line 1: Line 1:
 ====== Managing extended properties ====== ====== Managing extended properties ======
 +
 +{{tag> blog tsql extended_properties}}
 +
 [[https://​www.mssqltips.com/​sqlservertip/​5384/​working-with-sql-server-extended-properties/​|Extended properties]] are a means of attaching user-defined key-value pairs to database objects. This page provides some utility scripts to facilitate interaction with extended properties. ​ [[https://​www.mssqltips.com/​sqlservertip/​5384/​working-with-sql-server-extended-properties/​|Extended properties]] are a means of attaching user-defined key-value pairs to database objects. This page provides some utility scripts to facilitate interaction with extended properties. ​
  
-<WRAP center round info 60%>+<WRAP center round info 80%>
 Extended properties can be attached to many kinds of database object; the scripts here relate exclusively to properties attached to schema-scoped objects (represented in ''​sys.objects''​) and to columns (represented in ''​sys.columns''​). Extended properties can be attached to many kinds of database object; the scripts here relate exclusively to properties attached to schema-scoped objects (represented in ''​sys.objects''​) and to columns (represented in ''​sys.columns''​).
 </​WRAP>​ </​WRAP>​
Line 158: Line 161:
 --AND xp.[name] = '​MyNewProperty' ​ -- for example --AND xp.[name] = '​MyNewProperty' ​ -- for example
 </​code>​ </​code>​
- 
-{{tag> tsql extended_properties}} 
-~~DISCUSSION~~ 
  
  
 +~~NEWDISCUSSION~~