Help Center> MapReduce Service> Component Operation Guide> Using ClickHouse> Common ClickHouse SQL Syntax> DROP: Deleting a Table
View PDF

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 t1;