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. |