Previous Topic: Example 3Next Topic: Description

SQL Statements › DROP AREA

DROP AREA

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 AREA

YES

YES

NO

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

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 ALTER AREA statement:

►►── DROP AREA area-name ─────────────────────►◄

Note: Drop all tables in the area before attempting to drop the area. If the area contains any tables, the request will fail with SQLCODE -118 and DSF return code AHT.