v.18.16New Feature

New Feature: Column Comments in Table Descriptions with ALTER Support

Now you can specify comments for a column in the table description and change it using ALTER. #3377
Added the ability to specify and modify comments for table columns using the ALTER command in ClickHouse.

Why it matters

This feature allows users to add descriptive comments to columns within table definitions, improving schema documentation and clarity. It also enables updating these comments later without needing to recreate the table, enhancing maintainability and usability of metadata.

How to use it

When creating or altering a table, users can specify comments for individual columns in the table description. To change a column comment, use the ALTER TABLE statement with the relevant syntax to modify the column comment.