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 - Database Administration » Database Administration Utilities

Histogram utility (dbhist) Next Page

Information utility (dbinfo)

Displays information about the specified database.


dbinfo [ options ]

Option Description

Use this option to read in options from the specified environment variable or configuration file. See Using configuration files.

If you want to protect passwords or other information in the configuration file, you can use the File Hiding utility to obfuscate the contents of the configuration file. See File Hiding utility (dbfhide).

-c "keyword=value; ..."

Specify connection parameters. See Connection parameters.

Any valid user ID can run the Information utility, but to obtain page usage statistics you need DBA authority.

-o filename Write output messages to the named file.
-q Do not display output messages

Display information about the usage and size of all tables, including system and user-defined tables, as well as materialized views.

You can only request page usage statistics if no other users are connected to the database and you have DBA authority. The page usage information is obtained using the sa_table_page_usage system procedure.


The dbinfo utility displays information about a database. It reports the name of the database file, the name of any transaction log file or log mirror, the page size, the collation name and label, whether table encryption is enabled, and other information. Optionally, it can also provide table usage statistics and details.

Exit codes are 0 (success) or non-zero (failure).

For more information about exit codes, see Software component exit codes.