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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Reference » Using SQL » SQL functions » SQL functions (P-Z)

 

PROPERTY function [System]

Returns the value of the specified database server property as a string.

Syntax
PROPERTY( {  property-id  | property-name  } )
Parameters
  • 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.

Returns

VARCHAR

Remarks

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.

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

Example

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

SELECT PROPERTY( 'Name' );