![PROPERTY function [System]](arrow-left.gif){kind=icon}
![PROPERTY_NAME function [System]](arrow-right.gif){kind=icon}
Returns a description of a property.
PROPERTY_DESCRIPTION ( { property-id | property-name } )
CIS functional compensation performance considerations
apply. See “Conditions
that cause processing by SQL Anywhere” in Chapter
3, “Optimizing Queries and Deletions,” in
the Performance and Tuning Guide.
property-id An integer that is the property number of the property. This number can be determined from the PROPERTY_NUMBER function. The property-id is commonly used when looping through a set of properties.
property-name A string giving the name of the property. For property names, see the lists in “Connection properties”, “Properties available for the server”, and “Properties available for each database”.
The following statement returns the description “Number of index insertions:”
SELECT PROPERTY_DESCRIPTION( 'IndAdd' ) FROM iq_dummy
Each property has both a number and a name, but the number is subject to change between releases, and should not be used as a reliable identifier for a given property.
