Re: custom metadata

The COMMENT ON feature is exactly what I need. I just added my vote in 
favor of it.

In the meantime, I'll use Raymond's recommendation to check the column 
names for my "type" of table.

Thanks everyone for your recommendations.



On 8/2/2011 8:58 AM, Rick Hillegas wrote:
> On 7/30/11 2:36 PM, Patrick wrote:
> > I have an application that creates tables in a derby database. Some 
> > of the tables contain specific variables (i.e. predetermined column 
> > names) and, therefore, are of a certain "type". Some functions in the 
> > application only work with some "types" of tables. Is there a way to 
> > use metadata to identify which "type" of table a user has selected?
> >
> > Thanks
> Hi Patrick,
>
> Derby doesn't provide a mechanism to tag a table with extra metadata. 
> Some databases allow you to tag schema objects with comments. See 
> https://issues.apache.org/jira/browse/DERBY-4379. If that would solve 
> your problem, you may want to add a comment to that issue. You may 
> also want to vote for DERBY-4379 in order to boost its chances of 
> being addressed.
>
> Hope this helps,
> -Rick