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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » System Procedures » System procedures

sa_db_list system procedure Next Page

sa_db_properties system procedure


Reports database property information.

Syntax

sa_db_properties( [ dbidparm ] )

Arguments
Result set
Column nameData typeDescription
NumberINTEGERThe ID number of the database.
PropNumINTEGERThe database property number.
PropNameVARCHAR(255)The database property name.
PropDescriptionVARCHAR(255)The database property description.
ValueLONG VARCHARThe database property value.
Remarks

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.

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

Permissions

None

Side effects

None

See also
Example

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( );
NumberPropNumPropName...
00ConnCount...
01IdleCheck...
02IdleWrite...
............