DROP: Deleting a Table
This section describes the basic syntax and usage of the SQL statement for deleting a ClickHouse table.
Basic Syntax
DROP [TEMPORARY] TABLE [IF EXISTS] [database_name.]name [ON CLUSTER cluster]
Example
-- Delete the t1 table.
drop table t1;