Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: domain of john.vun@atosorigin.com
 designates 160.92.103.80 as permitted sender)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: how to insert table's and column's comment/remark using sql script
Date: Fri, 5 Sep 2008 11:53:37 +0800
Message-ID: <6C9240446B430E4382B717068FDD131B5F8F08@MYKLX001.myorigin.local>
Thread-Topic: how to insert table's and column's comment/remark using sql
 script
Thread-Index: AckPCvnZK1mJqvI6QY+U08g4/Kzojg==
From: "Vun, John" <john.vun@atosorigin.com>
To: <derby-user@db.apache.org>

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=20

COMMENT ON TABLE TABLE_NAME IS 'Table comment/remark';=20
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