v.24.8Improvement

Ensure COMMENT Clause Compatibility with All Table Engines

Ensure the COMMENT clause works for all table engines. #66832 (Joe Lynch).
The COMMENT clause is now supported for all table engines in ClickHouse.

Why it matters

This feature ensures that users can add descriptive comments to tables regardless of the table engine, improving metadata clarity and documentation consistency across different table types.

How to use it

To use this feature, include the COMMENT clause in your CREATE TABLE statement as follows:

CREATE TABLE table_name (
...
) ENGINE = engine_name
COMMENT 'Your descriptive comment here';


This will attach the comment to the table metadata for any supported engine.