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

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


sa_db_info system procedure

Reports database property information.

sa_db_info( [ 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 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.



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 11\Samples\demo.db
ConnCount 1
PageSize 4096
LogName C:\Documents and Settings\All Users\Documents\SQL Anywhere 11\Samples\demo.log