PROPERTY function [System]

PROPERTY( {  property-id  | property-name  }  [, second-parameter ] )

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

second-parameter You can specify a second parameter for some properties, as follows:

Property	Second parameter	Description
EventTypeDesc	positive-integer	Specify an event ID to return the event type description. See EventTypeDesc server property.
EventTypeName	positive-integer	Specify an event ID to return the event type name. See EventTypeName server property.
FunctionMaxParms	positive-integer	Specify a function number to return the maximum number of parameters that can be specified for the function. See FunctionMaxParms server property.
FunctionMinParms	positive-integer	Specify a function number to return the minimum number of parameters that must be specified for the function. See FunctionMinParms server property.
FunctionName	positive-integer	Specify a function number to return the function name. See FunctionName server property.
Message	positive-integer	Specify a line number to return the contents of the corresponding line in the database server messages window, prefixed by the date and time the message appeared. See Message server property
MessageText	positive-integer	Specify a line number to return the text associated with the specified line number in the database server messages window, without a date and time prefix. See MessageText server property.
MessageTime	positive-integer	Specify a line number to return the date and time associated with the specified line number in the database server messages window. See MessageTime server property.
RemoteCapability	positive-integer	Specify a remote capability ID to return the remote capability name associated with the ID. See RemoteCapability server property.

VARCHAR, LONG VARCHAR

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.

SQL/2008 Vendor extension.

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

SELECT PROPERTY( 'Name' );

PROPERTY function [System]

Syntax

Parameters

Returns

Remarks

See also

Standards and compatibility

Example