PROPERTY_NAME Function [System]

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

Syntax

PROPERTY_NAMEproperty-id )
Note: CIS functional compensation performance considerations apply.

Parameters

Parameter

Description

property-id

The property number of the property.

Returns

VARCHAR

Example

The following statement returns the property associated with property number 126. The actual property to which this refers changes from version to version.

SELECT PROPERTY_NAME( 126 ) FROM iq_dummy

Standards and Compatibility

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

  • Sybase—Not supported by Adaptive Server Enterprise.

Related concepts
Properties Available for the Server
Properties Available for Each Database
Connection Properties
Related reference
PROPERTY Function [System]
PROPERTY_NUMBER Function [System]
CONNECTION_PROPERTY Function [System]