Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

Deleting Data

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.
ALTER TABLE ... DELETE Learn how to delete rows using a mutation.
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.
Manage data with TTL Learn how to use TTL (time-to-live) to expire and delete data automatically.
Navigation