v.19.13New Feature

RENAME Queries Now Work with All Storages

RENAME queries now work with all storages. #5953 (Ivan)
The RENAME query capability has been extended to work with all storage engines in ClickHouse.

Why it matters

Previously, RENAME queries were limited to certain storage types, restricting schema evolution flexibility. With this update, users can now rename tables or tablespaces regardless of the underlying storage engine, improving usability and management of ClickHouse databases.

How to use it

Users can simply use the RENAME query as usual on any table, regardless of its storage engine. For example:

RENAME TABLE old_table_name TO new_table_name;