Re: custom metadata Patrick Meyer Tue Aug 02 09:01:17 2011The 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?ThanksHi 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