Lukas Eder created DERBY-7008:
---------------------------------
Summary: Add support for COMMENT ON [ object ] IS '...' statements
Key: DERBY-7008
URL: https://issues.apache.org/jira/browse/DERBY-7008
Project: Derby
Issue Type: Improvement
Components: SQL
Affects Versions: 10.14.2.0
Reporter: Lukas Eder
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
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
