PROPERTY_NUMBER Function [System]

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

Syntax

PROPERTY_NUMBER ( property-name )
Note: CIS functional compensation performance considerations apply.

Parameters

Parameter

Description

property-name

A property name.

Returns

INT

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

  • SQL—Vendor extension to ISO/ANSI SQL grammar.

  • Sybase—Not supported by Adaptive Server Enterprise.

Parent topic: Alphabetical List of Functions
Related concepts
Properties Available for the Server
Properties Available for Each Database
Connection Properties
Related reference
PROPERTY Function [System]
PROPERTY_NAME Function [System]
CONNECTION_PROPERTY Function [System]