Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

PROPERTY function [System]

Returns the value of the specified server-level property as a string.

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

property-id    An integer that is the property-number of the server-level 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.

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.

• Server-level properties

• SQL/2003    Vendor extension.

The following statement returns the name of the current database server:

SELECT PROPERTY( 'Name' );