DROP TABLE

Use the DROP TABLE command to drop an existing table.

You cannot drop a table if it is referenced by other objects, such as triggers, or if it contains any data. You also cannot drop system tables, which hold metadata about ObjectServer objects.

Syntax

DROP TABLE [database_name.]table_name;

Example

To delete all rows of a table:

delete from mytab;

To drop the table:

drop table mytab;