|
Reports database property information.
sa_db_info( [ 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 connection. |
| Alias | VARCHAR(255) | The database name. |
| File | VARCHAR(255) | The file name of the database root file, including path. |
| ConnCount | INTEGER | The number of connections to the database. |
| PageSize | INTEGER | The page size of the database, in bytes. |
| LogName | VARCHAR(255) | The file name of the transaction log, including path. |
If you specify a database ID, sa_db_info returns a single row containing the Number, Alias, File, ConnCount, PageSize, and LogName for the specified database.
If no dbidparm is supplied, properties for all databases are returned.
None
None
The following statement returns a row for each database that is running on the server:
CALL sa_db_info( );
| Property | Value |
|---|---|
| Number | 0 |
| Alias | demo |
| File | C:\Documents and Settings\All Users\Documents\SQL Anywhere 10\Samples\demo.db |
| ConnCount | 1 |
| PageSize | 4096 |
| LogName | C:\Documents and Settings\All Users\Documents\SQL Anywhere 10\Samples\demo.log |