![POWER function [Numeric]](arrow-left.gif){kind=icon}
![PROPERTY_DESCRIPTION function [System]](arrow-right.gif){kind=icon}
Returns the value of the specified server-level property as a string.
PROPERTY ( { 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 server-level 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. See “Properties available for the server” for a list of server property names.
The following statement returns the name of the current database server:
SELECT PROPERTY( 'Name' ) FROM iq_dummy
Each property has both a number and a name, but the number is subject to change between versions, and should not be used as a reliable identifier for a given property.
