db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vun, John" <john....@atosorigin.com>
Subject how to insert table's and column's comment/remark using sql script
Date Fri, 05 Sep 2008 03:53:37 GMT
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


Mime
View raw message