DROP TABLE

Deletes the table.

See also:

• CREATE TABLE
• UNDROP TABLE

Syntax

DROP TABLE [IF EXISTS] [db.]name

caution

DROP TABLE only remove the table schema from meta service, we do not remove the underlying data from the storage. If you want to delete the data and table all, please use:

DROP TABLE <table_name> ALL;

Examples

CREATE TABLE test(a INT, b VARCHAR);
DROP TABLE test;