| Contains extended properties that can be defined on various objects in a database. The extended properties are a new SQL Server 2000 feature. These extended properties can be used to store a caption for a table, view, or column, to store an input mask for a column, to store the formatting rules for displaying the data in a column, and so on. The sysproperties table is used by the sp_droptype, sp_validatepropertyinputs, sp_addextendedproperty, sp_updateextendedproperty, sp_dropextendedproperty and sp_revokedbaccess system stored procedures to manage extended properties, and by the fn_listextendedproperty system function to retrieve the value of an existing extended property. Each database contains sysproperties system table. | Column name | Data type | Description |
|---|
| id | int | Extended property id. | | smallid | smallint | Data type id, or column id, or user id, or index id. | | type | tinyint | Extended property type. | | name | sysname | User-defined name of an extended property. | | value | sql_variant, nullable | The value of an extended property. It can contains up to 7,500 bytes of data. |
|