Extended properties

Extended properties attach custom name/value metadata to database objects — a caption, a description, an input mask, and so on. Querona supports them on databases, schemas, tables and views, columns, indexes and foreign keys.

Objects are classified into levels: level 0 is the database scope (for example a schema), level 1 is contained in a schema (a table or view), and level 2 is contained by a level-1 object (a column or index). With no object specified, the property belongs to the database itself.

Add, update and drop properties with the stored procedures below; read them with fn_listextendedproperty and query them through the sys.extended_properties catalog view.

Stored procedure name	Description
sp_addextendedproperty	Adds a new extended property to a database object.
sp_dropextendedproperty	Drops an existing extended property.
sp_updateextendedproperty	Updates the value of an existing extended property.