The DROP TABLE statement deletes all data and indexes for a table and erases its entry in the system catalog.

If a multi-tenant table is dropped, then, the DROP TABLE deletes the table partition for every tenant defined in the table.

You can also use the DROP TABLE statement to drop a partitioned table. When a partitioned table is dropped, all the table, index, and LOB partitions of the table are deleted.

Syntax

The DROP TABLE statement uses the following syntax:

DROP TABLE  [owner_name.]table_name ;

Example: DROP TABLE statement

The following example illustrates the use of a DROP TABLE statement.

 DROP TABLE SPORTS.staff;