DROP TABLE

This statement removes a table and all its data from the database.

To support DROP TABLE processing, the IP GETSUPPORT operation must return TRUE for IP_SUPPORT_DROP_TABLE.

Syntax

DROP table_name [CASCADE | RESTRICT] 

Examples

DROP TABLE test_data;
DROP TABLE emp CASCADE;
DROP TABLE emp RESTRICT;