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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database configuration » Connection, database, and database server properties

 

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;

 See also