Delete Data

Use the DROP or TRUNCATE statements to delete data. DROP deletes both metadata and data, while TRUNCATE only deletes data.

Basic Syntax:


DROP DATABASE [IF EXISTS] db [ON CLUSTER ck_cluster]DROP [TEMPORARY] TABLE [IF EXISTS] [db.]name [ON CLUSTER ck_cluster]
TRUNCATE TABLE [IF EXISTS] [db.]name [ON CLUSTER ck_cluster]