Closes databases, including their tables and indexes.


CLOSE DATABASES [<database name list>]

<database name list>

The list of database names, separated by commas. If no list is specified, all open databases are closed.


Closing a database closes all the open tables in the database, including all the index, memo, and other associated files. For the default database, which gives access to DBF and DB tables, this means all open tables in all work areas.

CLOSE DATABASES only closes those tables opened in the current workset. For more information on worksets, see CREATE SESSION.


Set the active property of the Database object (or all its Query objects) to false.