Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

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 the DB_ID function. Typically, the database name is used.

database-name    The name of the database, as returned by the DB_NAME function.

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

• DB_ID function [System]
• DB_NAME function [System]
• Database-level properties

• SQL/2003    Vendor extension.

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

SELECT DB_PROPERTY( 'PAGESIZE' );