v.22.4Improvement

support ALTER TABLE t DETACH PARTITION (ALL)

support ALTER TABLE t DETACH PARTITION (ALL). #35794 (awakeljw).
ClickHouse now supports the ALTER TABLE t DETACH PARTITION (ALL) command to detach all partitions from a table in a single operation.

Why it matters

This feature enables users to efficiently detach every partition of a table without specifying each partition individually. It simplifies and speeds up managing table partitions, especially for large tables or when performing maintenance tasks.

How to use it

Use the SQL syntax:

ALTER TABLE t DETACH PARTITION (ALL);


This command detaches all partitions from the table t at once.