db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lukas Eder (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-7008) Add support for COMMENT ON [ object ] IS '...' statements
Date Fri, 21 Sep 2018 08:56:00 GMT
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:
            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

View raw message