DROP TABLE

Deletes the table.

See also:

• CREATE TABLE
• UNDROP TABLE
• TRUNCATE 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.

Examples

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