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. #3377Why 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 theALTER TABLE statement with the relevant syntax to modify the column comment.