Hi John,
Derby does not provide a COMMENT command. Off the top of my head, this
seems like a fairly easy feature to add to Derby.
Alternatively, you could write an ADD_COMMENT procedure which stores
descriptive text in tables supplied by your application. However,
because you can't declare foreign keys which reference system tables
(the tables in Derby's SYS schema), you would have to manually clean up
your commentary tables when you drop schema objects. The Derby system
tables are documented in the Reference Guide:
http://db.apache.org/derby/docs/10.4/ref/
Hope this helps,
-Rick
Vun, John wrote:
Hi,
Good Day !
Need help on how to insert table's and column's comment/remark using sql
script for derby database (From NetBean IDE 6.0)? What is the syntax to
insert table and column's comment/remark ?
For example, oracle syntax like below
COMMENT ON TABLE TABLE_NAME IS 'Table comment/remark';
COMMENT ON COLUMN TABLE_NAME.COLUMN_NAME IS 'column comment/remark';
And after insert, how to view or display it ? (From NetBean IDE 6.0 or
SQuirrelL SQL Client 2.6.6)
Regards,
John Vun
