close database

Close an open database

Syntax

close_db_stmt:
          CLOSE DATABASE database_name

Description

The CLOSE DATABASE statement can be used to close any open database. Attempts to execute a CLOSE DATABASE statement when a transaction is active will result in an error.

Example

open bookshop;
...access bookshop database
close database bookshop;
open database nsfawards;
...access nsfawards database
close database nsfawards;