SHOW DATABASE
From InterBase
Go Up to isql Command Reference
Displays information about the current database.
SHOW [DATABASE | DB];
Description: SHOW DATABASE
displays the current database’s file name, page size and allocation, and sweep interval.
The output of SHOW DATABASE
is used to verify data definition or to administer the database. For example, use the backup and restore utilities to change page size or reallocate pages among multiple files, and use the database maintenance utility to change the sweep interval.
SHOW DATABASE
has a shorthand equivalent, SHOW DB
.
Example: The following example connects to a database and displays information about it:
CONNECT 'employee.ib';
Database: employee.ib
SHOW DB;
Database: employee.ib
Owner: SYSDBA
PAGE_SIZE 4096
Number of DB pages allocated = 422
Sweep interval = 20000