DB_PROPERTY function [System]

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.

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

SELECT DB_PROPERTY( 'PAGESIZE' ) FROM iq_dummy

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