Previous Topic: DescriptionNext Topic: Description

SQL Statements › DROP DATABASE

DROP DATABASE

In the following table, YES indicates a valid execution method for this statement.

This SQL statement can be executed in the following ways:

Through the CA Datacom Datadictionary Interactive SQL Service Facility (interactive)

In an application program prepared using a CA Datacom/DB SQL Preprocessor (embedded)

By using CA Dataquery (SQL & Batch Modes)

DROP DATABASE

YES

YES

NO

Note: YES indicates a valid execution method for this statement.

To learn about using SQL keywords in CA Dataquery, see the CA Dataquery User Guide.

For information about the access rights required to execute this statement, see the CA Datacom/DB Database and System Administration Guide.

Following is the syntax diagram for the DROP DATABASE statement:

►►── DROP DATABASE database-name ┬────────────────────┬─►◄
                                 └─ DATACOM OBSOLETE ─┘

Note: All AREAs must be dropped before the database can be dropped, unless the OBSOLETE option is used. If areas exist, the request is rejected with SQLCODE -118 and DSF return code BHA.