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

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » System Objects » System procedures » Alphabetical list of system procedures


sa_db_properties system procedure

Reports database property information.

sa_db_properties( [ dbidparm ] )
  • dbidparm¬†¬† Use this optional INTEGER parameter to specify the ID number of a database.

Result set
Column name Data type Description
Number INTEGER The ID number of the database.
PropNum INTEGER The database property number.
PropName VARCHAR(255) The database property name.
PropDescription VARCHAR(255) The database property description.
Value LONG VARCHAR The database property value.

If you specify a database ID, the sa_db_properties system procedure returns the database ID number and the PropNum, PropName, PropDescription, and Value for each available database property. Values are returned for all database properties and statistics related to databases. Valid properties with NULL values are also returned.

If dbidparm is not specified, properties for all databases are returned.



Side effects


See also

The following example uses the sa_db_properties system procedure to return a result set summarizing database property information for all databases.

CALL sa_db_properties( );
Number PropNum PropName ...
0 0 ConnCount ...
0 1 IdleCheck ...
0 2 IdleWrite ...
... ... ... ...