ALTER DATABASE ... MODIFY COMMENT

Adds, modifies, or removes comment to the table, regardless if it was set before or not. Comment change is reflected in both system.databases and SHOW CREATE DATABASE query.

Syntax

Examples

Creating a DATABASE with comment (for more information, see the COMMENT clause):

Modifying the table comment:

Output of a new comment:

Removing the database comment:

Output of a removed comment: