Deleting Data - ClickHouse Documentation

In this section of the documentation, we will explore how to delete data in ClickHouse.

Page	Description
Overview	Provides an overview of the various ways to delete data in ClickHouse.
Lightweight deletes	Learn how to use the Lightweight Delete to delete data.
Delete mutations	Learn about Delete Mutations.
Truncate table	Learn about how to use Truncate, which allows the data in a table or database to be removed, while preserving its existence.
Drop partitions	Learn about Dropping Partitions in ClickHouse.

Last modified on June 29, 2026