You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Geoff hendrey <ge...@yahoo.com> on 2007/09/08 00:19:25 UTC

need to *set* REMARKS field of DatabaseMetaData

I want to use the REMARKS column of DatabaseMetaData to store remarks about a column.
I see how to retrieve the REMARKS, but how would I go about *setting* the REMARKS.


-geoff




Re: need to *set* REMARKS field of DatabaseMetaData

Posted by Rick Hillegas <Ri...@Sun.COM>.
Hi Geoff,

Several DatabaseMetaData methods return ResultSets which have a column 
named REMARKS. For instance, getColumns(), getTables(), and 
getProcedures() return ResultSets which contain a REMARKS column. The 
contents of these columns are determined by queries stored in the 
following Derby source file: 
java/engine/org/apache/derby/impl/jdbc/metadata.properties. In order to 
change the contents of these columns, you would have to edit those 
queries and build your own Derby engine.

Hope this helps,
-Rick

Geoff hendrey wrote:
> I want to use the REMARKS column of DatabaseMetaData to store remarks 
> about a column.
> I see how to retrieve the REMARKS, but how would I go about *setting* 
> the REMARKS.
>
> -geoff
>
>