Skip to main content
Skip to main content
Edit this page

Deleting Data

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

PageDescription
OverviewProvides an overview of the various ways to delete data in ClickHouse.
Lightweight DeletesLearn how to use the Lightweight Delete to delete data.
Delete MutationsLearn about Delete Mutations.
Truncate TableLearn about how to use Truncate, which allows the data in a table or database to be removed, while preserving its existence.
Drop PartitionsLearn about Dropping Partitions in ClickHouse.
Try ClickHouse Cloud for FREE

Separation of storage and compute, automatic scaling, built-in SQL console, and lots more. $300 in free credits when signing up.

Try it for Free