PROPERTY_NAME function [System]

Function

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

Syntax

PROPERTY_NAME ( property-id )

CIS functional compensation performance considerations apply. See “Conditions that cause processing by SQL Anywhere” in Chapter 3, “Optimizing Queries and Deletions,” in the Performance and Tuning Guide.

Parameters

property-id The property number of the property.

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.