ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

PROPERTY_DESCRIPTION function [System]

Function 

Returns a description of a property.

Syntax 

PROPERTY_DESCRIPTION ( {  property-id  | property-name  } )

Parameters 

property-id    An integer that is the property-number of the database property. This number can be determined from the PROPERTY_NUMBER function. The property-id is commonly used when looping through a set of properties.

property-name    A string giving the name of the database property.

Usage 

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.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported by Adaptive Server Enterprise.

See also 

Database Performance and Connection Properties

Example 

The following statement returns the description Number of index insertions.

SELECT PROPERTY_DESCRIPTION( 'IndAdd' )