v.20.7Improvement

Support TRUNCATE table without TABLE keyword

Support TRUNCATE table without TABLE keyword. #12653 (Winter Zhang).
Support for using the TRUNCATE statement without the TABLE keyword in ClickHouse.

Why it matters

This feature simplifies the syntax for truncating tables by allowing users to omit the TABLE keyword, making the command more concise and aligned with SQL standards and user expectations.

How to use it

Users can now execute the command as follows without the TABLE keyword:

TRUNCATE table_name


or simply:

TRUNCATE table_name


(where table_name is the target table to be truncated).