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

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.

Returns

VARCHAR

Example

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

SELECT DB_PROPERTY( 'PAGESIZE' ) FROM iq_dummy

Usage

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

Standards and Compatibility

  • SQL—Vendor extension to ISO/ANSI SQL grammar.

  • Sybase—Not supported by Adaptive Server Enterprise.

Related reference
COL_NAME Function [System]
DB_ID Function [System]
DB_NAME Function [System]
NEXT_DATABASE Function [System]
OBJECT_ID Function [System]
OBJECT_NAME Function [System]