Subject | Re: [firebird-support] Comments in Firebird |
---|---|
Author | Martijn Tonies |
Post date | 2003-07-14T12:27:26Z |
Hi Tim,
(spelled it right this time :)
know if IBOConsole supports that with the metadata extract.
Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com
(spelled it right this time :)
> > > Is there any way of adding comments that will be stored with themetadata?
> >procedure-parameters,
> >Yes, most objects (tables, views, columns, procedure,
> >exceptions, indices) support comments via a column RDB$DESCRIPTIONWorkbench
> >in the system tables.
> >
> >Most developer tools allow you to enter a description - Database
> >does as well - and there are a couple of other (free?) tools toshow/print
> >these descriptions. Check www.ibphoenix.com for a list.But
>
> Yep - checked, and can see where and how to add comments to tables etc.
> the one thing I can't add comments to is the DB metatdata. I.e., theRDB$DATABASE has a RDB$DESCRIPTION column as well. But I don't
> database itself seems to not have a comments field / record.
know if IBOConsole supports that with the metadata extract.
> This may sound petty - but I have a situation where I would like to addthe
> versions of the two software products that use the db to the metatdata, asWith regards,
> well as the metedata version itself. Then the engineers who are installing
> or upgrading the software would be able to see the versions simply by
> viewing the db metatdata in IBOConsole or similar.
Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com