DROP DATABASE

The DROP DATABASE statement removes a database from IMS. Whenever a database is deleted, its description is deleted from the catalog at the current IMS.

Invocation

This statement can be submitted from a Java™ application program with an establish connection to IMS through the IMS Universal JDBC drivers. It is an executable statement that cannot be dynamically prepared.

Syntax

Read syntax diagramSkip visual syntax diagramDROPDATABASE database_name

Description

The following keyword parameters are defined for the DROP DATABASE statement:

DATABASE database_name
Identifies the database to drop. The name must identify a database that exists in IMS. When a database is dropped, all of its tables, indexes are also dropped.

Usage notes

Any objects of the database (such as table spaces, tables, and columns) and pending changes are also dropped.

If a physical database is dropped, no checking is done to determine if a logical database references the physical database. The physical database may be deleted even if it is referenced by a logical database. If the physical database is deleted, the user must update the logical database so that it no longer references the physical database.

Example

Assuming you have already created a database with the following example (see CREATE DATABASE), and you now want to drop the database:

DROP DATABASE hospdbd1