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 Patrick <me...@virginia.edu> on 2011/07/30 23:36:21 UTC

custom metadata

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

Re: custom metadata

Posted by Patrick Meyer <me...@gmail.com>.
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

Re: custom metadata

Posted by Rick Hillegas <ri...@oracle.com>.
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