Reports database property information.
sa_db_properties( [ dbidparm ] )
dbidparm Use this optional INTEGER parameter to specify the ID number of a database.
| 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.
None
None
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 | ... |
| ... | ... | ... | ... |
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |