Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sysproperties table Expand / Collapse
Author
Message
Posted Tuesday, February 10, 2004 2:12 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 23, 2012 1:51 AM
Points: 44, Visits: 7

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

Post #99631
Posted Tuesday, February 10, 2004 5:35 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 6:58 PM
Points: 871, Visits: 286

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,



Post #99689
Posted Wednesday, February 11, 2004 2:46 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 23, 2012 1:51 AM
Points: 44, Visits: 7

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

Post #99741
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse