On this page

DROP: Deleting a Table

Updated on 2022-11-18 GMT+08:00

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

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback