v.21.12Improvements

Prevent Dependency-Related Dropping of Tables or Dictionaries

Official CH changelog text
Do not allow to drop a table or dictionary if some tables or dictionaries depend on it. #30977 (tavplubix).
Prevents dropping tables or dictionaries that have dependent tables or dictionaries in ClickHouse.

Why it matters

This feature ensures data integrity by disallowing the removal of a table or dictionary if other tables or dictionaries depend on it, preventing accidental data loss or broken dependencies.

How to use it

This behavior is applied automatically. When attempting to drop a table or dictionary, ClickHouse will check for dependencies and block the operation if any exist.

Related resources

PreviousNext