Bug #25370 database comment

• Submitted: 2 Jan 2007 16:28
• Modified: 29 Dec 2009 6:42
• Reporter: Hans Ginzel
• Status: Verified
• Category: MySQL Server: DDL
• Severity: S4 (Feature request)
• Version: 5.0, 5.1, 8.0
• OS: Linux (All OS)
• CPU Architecture: Any
• Tags: database comment

[2 Jan 2007 16:28] Hans Ginzel

Description:
Add comments to databases/schemas (varchar(255)).

How to repeat:
desc information_schema.SCHEMATA;

Suggested fix:
alter table information_schema.SCHEMATA
add column SCHEMA_COMMENT varchar(255);

CREATE DATABASE xxx COMMENT 'comment';

ALTER DATABASE COMMENT 'other comment';

in documentation

ALTER {DATABASE | SCHEMA} [db_name]
    alter_specification [, alter_specification] ...

alter_specification:
    database_option ...

[29 Dec 2009 6:42] Susanne Ebrecht

Many thanks for a reasonable feature request.

[15 Nov 2012 9:46] Pavel Dobryakov

Is-there any plans to implement this feature?

[16 Aug 2023 12:28] MySQL Verification Team

Bug #112070 marked as duplicate of this one.