|
Returns the value of the specified database server property as a string.
PROPERTY( { property-id | property-name } [, second-parameter ] )
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.
A string giving the name of the database property.
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. |
| EventTypeName | positive-integer | Specify an event ID to return the event type name. |
| FunctionMaxParms | positive-integer | Specify a function number to return the maximum number of parameters that can be specified for the function. |
| FunctionMinParms | positive-integer | Specify a function number to return the minimum number of parameters that must be specified for the function. |
| FunctionName | positive-integer | Specify a function number to return the function name. |
| 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. |
| 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. |
| 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. |
| RemoteCapability | positive-integer | Specify a remote capability ID to return the remote capability name associated with the ID. |
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.
Not in the standard.
The following statement returns the name of the current database server:
SELECT PROPERTY( 'Name' );