sys.extended_properties

Contents

sys.extended_properties#

Returns a row for each extended property in the current database.

Column name

Data type

Description

class

tinyint

Identifies the class of item on which the property exists. Can be one of the following values:

  • 0 = Database

  • 1 = Object or column

  • 3 = Schema

  • 7 = Index

class_desc

nvarchar(60)

Description of the class on which the extended property exists. Can be one of the following values:

  • DATABASE

  • OBJECT_OR_COLUMN

  • SCHEMA

  • INDEX

major_id

int

ID of the item on which the extended property exists, interpreted according to its class. For most items, this is the ID that applies to what the class represents. Interpretation for nonstandard major IDs is as follows:

  • If class is 0, major_id is always 0

  • If class is 1 or 7, major_id is object_id

minor_id

int

Secondary ID of the item on which the extended property exists, interpreted according to its class. For most items this is 0; otherwise, the ID is as follows:

  • If class is 1, minor_id is the column_id if column, else 0 if object

  • If class is 7, minor_id is the index_id

name

sysname

Property name, unique with class, major_id, and minor_id.

value

sql_variant

Value of the extended property.

See Also#

Contents