ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

DB_PROPERTY function [System]

Function 

Returns the value of the given property.

Syntax 

DB_PROPERTY (
{  property_id  |  property_name  }
[, { database_id | database_name  } ] )

Parameters 

property_id    The database property ID.

property_name    The database property name.

database_id    The database ID number, as returned by DB_ID. Typically, the database name is used.

database_name    The name of the database, as returned by DB_NAME.

Usage 

Returns a string. The current database is used if the second argument is omitted.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported by Adaptive Server Enterprise.

See also 

DB_ID function [System]

DB_NAME function [System]

Database-level properties

Example 

The following statement returns the page size of the current database, in bytes.

SELECT DB_PROPERTY( 'PAGESIZE' )