PROPERTY_NAME function [System]

Returns the name of the property with the supplied property ID for the specified connection level.

Syntax
PROPERTY_NAME( property-id [, property-scope ] )
property-scope:
NULL
| 'server'
| 'database'
| 'db'
| 'connection'
| 'conn'
Parameters
  • property-id   The property ID of the database property.

  • property-scope   The scope of the property, or NULL.

Returns

VARCHAR

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Example

The following statement returns the server-level property associated with property ID 102.

SELECT PROPERTY_NAME( 102, 'server' );