DB_PROPERTY Function [System]

Returns the value of the given property.

Syntax

DB_PROPERTY ( { property-id | property-name }
[ , { database-id | database-name } ] )

Note: CIS functional compensation performance considerations apply.

Parameters
Parameter	Description
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.

VARCHAR

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

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

SELECT DB_PROPERTY( 'PAGESIZE' ) FROM iq_dummy