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.