ALTER DATABASE ... MODIFY COMMENT

Adds, modifies, or removes comment to the database, regardless of whether it was set before. 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:

Was this page helpful?

Try ClickHouse Cloud for FREE

Separation of storage and compute, automatic scaling, built-in SQL console, and lots more. $300 in free credits when signing up.

Try it for Free