ASA SQL Reference
SQL Functions
Alphabetical list of functions
Returns the value of the given property.
DB_PROPERTY (
{ property_id | property_name }
[, { database_id | database_name } ] )
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.
Returns a string. The current database is used if the second argument is omitted.
SQL/92 Vendor extension.
SQL/99 Vendor extension.
Sybase Not supported by Adaptive Server Enterprise.
The following statement returns the page size of the current database, in bytes.
SELECT DB_PROPERTY( 'PAGESIZE' )