Sysproperties table

  • Does anyone have any documentation for the sysproperties table? It doesn't appear to be mentioned in Books Online at all.

    In particular, I'm interested in the 'type' field and would like a complete list of all possible values and their respective meanings.

     

    Thanks

    Ben

  • sysproperties

    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 nameData typeDescription
    idintExtended property id.
    smallidsmallintData type id, or column id, or user id, or index id.
    typetinyintExtended property type.
    namesysnameUser-defined name of an extended property.
    valuesql_variant, nullableThe value of an extended property. It can contains up to 7,500 bytes of data.


    Kindest Regards,

  • Excellent! That certainly helps. Does anyone know what all the possible values sotred in the Type field are. So far I've seen the following values:

    3 - Diagram information

    4 - Table column description

     

    I hope I don't have to try and get a complete list through trial-and-error!

    Ben

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply