DROP

The DROP statement deletes a table or index.

Invocation

This statement can be used in an application program using the DB2 CLI functions or issued through the CLP.

Syntax

>>-DROP--+-TABLE--table-name-+---------------------------------><
         '-INDEX--index-name-'
 
 

Description

TABLE table-name

Identifies the base table that is to be dropped. table-name must identify a table that is described in the catalog (SQLSTATE 42704).

INDEX index-name

Identifies the index that is to be dropped. The index-name must identify an index that is described in the catalog (SQLSTATE 42704). It cannot be an index required by the system for a primary key (SQLSTATE 42704).

Rules

None.

Notes

• Tables and indexes should not be dropped when a table is in use (a statement handle is active on a query which uses that table or index). Dropping tables and indexes that are in use will invalidate statement handles which involve the table or index.

Example

Drop table EMPLOYEE.

     DROP TABLE EMPLOYEE

Related reference

• Overview of DB2 Everyplace SQL statement support
• Data type compatibility for assignments and comparisons
• DB2 Everyplace supported parameter markers
• SQLState listing
• Summary of SQLState class codes