DB_PROPERTY function [System]

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 the DB_ID function. Typically, the database name is used.
database-name The name of the database, as returned by the DB_NAME function.

VARCHAR, LONG VARCHAR

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

Cloud note: Because of tenant database isolation rules, when this function is called in the cloud it returns only information about the current tenant database.

SQL/2008 Vendor extension.

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

SELECT DB_PROPERTY( 'PageSize' );

DB_PROPERTY function [System]

Syntax

Parameters

Returns

Remarks

See also

Standards and compatibility

Example