PROPERTY_NUMBER function [System]

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

Syntax

PROPERTY_NUMBER( property-name )

Parameters

property-name
A property name.

Returns

INT

Remarks

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. When either property number or property name can be used, it is preferable to use the property name. Always use the PROPERTY_NUMBER function to ensure that the property number is current for the server being used.

Standards

ANSI/ISO SQL Standard
Not in the standard.

Example

The following statement returns the property number of the PAGESIZE property as an integer:

SELECT PROPERTY_NUMBER( 'PAGESIZE' );