PROPERTY_NUMBER function [System]

Function

Returns the property number of the property with the supplied property name.

Syntax

PROPERTY_NUMBER ( property-name )

Parameters

property-name A property name. For property names, see the lists in “Connection properties”, “Properties available for the server”, and “Properties available for each database”.

Example

The following statement returns an integer value. The actual value changes from version to version.

SELECT PROPERTY_NUMBER( 'PAGESIZE' ) FROM iq_dummy

Standards and compatibility

SQL92 Vendor extension.

Sybase Not supported by Adaptive Server Enterprise.

See also

“Connection properties”

“Properties available for the server”

“Properties available for each database”