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_convert_timestamp_to_ml_progress system procedure Next Page

sa_db_info system procedure

Reports database property information.


sa_db_info( [ dbidparm ] )

Result set
Column nameData typeDescription
NumberINTEGERThe ID number of the connection.
AliasVARCHAR(255)The database name.
FileVARCHAR(255)The file name of the database root file, including path.
ConnCountINTEGERThe number of connections to the database.
PageSizeINTEGERThe 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.



Side effects


See also

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