ALTER TABLE ... MODIFY COMMENT
Adds, modifies, or removes a table comment, regardless of whether it was set
before or not. The comment change is reflected in both system.tables
and in the SHOW CREATE TABLE query.
Syntax
Examples
To create a table with a comment:
To modify the table comment:
To view the modified comment:
To remove the table comment:
To verify that the comment was removed:
Caveats
For Replicated tables, the comment can be different on different replicas. Modifying the comment applies to a single replica.
The feature is available since version 23.9. It does not work in previous ClickHouse versions.