[DERBY-7008] Add support for COMMENT ON [ object ] IS '...' statements

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.14.2.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Lukas Eder
• Created: 21/Sep/18 08:55
• Updated: 22/Sep/18 00:53

Description

A lot of RDBMS support some way of commenting on stored objects. For instance, Oracle has this syntax:

COMMENT ON <object> IS 'some comment'

This is very useful when navigating an unknown schema, for instance to explain the meaning of a column with some encoded values, etc. Also, there is tool support when these comments are exposed through the dictionary views and/or through JDBC's DatabaseMetaData

I personally prefer Oracle's syntax over e.g. MySQL's (inline comments in CREATE TABLE) or SQL Server's (some system function).

Ideally, all objects can receive comments, including:

• Tables (and views, etc.)
• Columns
• Routines
• Schemas
• Indexes
• etc.

But I think the most important ones are tables and columns