v.23.11Improvement

Allow Basic Commands in ALTER for TEMPORARY Tables

Allow basic commands in ALTER for TEMPORARY tables. #56892 (Sergey).
Allow execution of basic ALTER commands on TEMPORARY tables in ClickHouse.

Why it matters

This feature enables users to perform essential ALTER operations on temporary tables, which were previously restricted. It improves flexibility and usability when working with temporary tables by allowing schema adjustments without recreating them.

How to use it

Simply use standard ALTER commands on tables created with the TEMPORARY keyword as you would with permanent tables, for example:

ALTER TEMPORARY TABLE table_name ...