sa_db_info system procedure

Reports database property information.

Syntax
sa_db_info( [ dbidparm ] )
Arguments
  • 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.
Remarks

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.

Permissions

None

Side effects

None

See also
Example

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