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.
