skip to main content
SQL statements : DDL statements : DROP TABLE
 

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;