v.21.11New Features

Implemented ALTER TABLE x MODIFY COMMENT Feature

Implemented ALTER TABLE x MODIFY COMMENT. #29264 (Vasily Nemkov).
Implemented the ALTER TABLE x MODIFY COMMENT syntax to allow modifying comments on existing tables.

Why it matters

This feature enables users to update or change the comment metadata of tables without recreating them, improving schema management and documentation.

How to use it

Use the ALTER TABLE [table_name] MODIFY COMMENT 'new comment' statement to change the comment of an existing table.