Accessing database property values

Database properties are available for each database on the database server. You can use the DB_PROPERTY system function to retrieve the value for an individual property, or you can use the sa_db_properties system procedure to retrieve the values of all database properties.

Prerequisites

There are no prerequisites for this task.

Context and remarks

Property names are case insensitive.

Task

Use one of the following methods to access database property values:

Option	Action
Retrieve the value of a database property	Use the DB_PROPERTY system function.
Retrieve the values of all database properties	Use the sa_db_properties system procedure.

Results

The database property value is returned.

Example

The following statement returns the page size of the current database:

SELECT DB_PROPERTY ( 'PageSize' );

Use the sa_db_properties system procedure to retrieve the values of all database properties:

CALL sa_db_properties;

Accessing database property values

Task

See also