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 the sections “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 release to release.

SELECT PROPERTY_NUMBER( 'PAGESIZE' ) FROM iq_dummy

Standards and compatibility

SQL/92 Vendor extension.

Sybase Not supported by Adaptive Server Enterprise.

See also

“Connection properties”

“Properties available for the server”

“Properties available for each database”