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.

Prérequis

There are no prerequisites for this task.

Contexte et remarques

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.

Résultat

The database property value is returned.

Exemple

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