COMMENT ON DATABASE
Valid in: SQL
The COMMENT ON DATABASE statement adds, updates, or deletes a comment on a database.
You can add, update, or delete database comments in the following ways:
• Using iidbdb, applies the change to all user databases.
• Using a user database, applies the change only to that specific database.
Syntax using iidbdb:
To add or update database comment use the following syntax:
comment on database DBNAME is 'Comment 1'; \g
To delete a database comment use the following syntax:
comment on database DBNAME is ''; \g
Syntax using user database:
To add or update database comment use the following syntax:
comment on database [DBNAME] is 'Comment 1'; \g
To delete a database comment use the following syntax:
comment on database DBNAME is ''; \g
Last modified date: 01/27/2026