|Subject||Re: [firebird-support] Getting access to column description info|
> > > I would like to use the data dictionary information in my database,to
> > > particularly the Description information, for columns to be displayed
> > > users when they ask for further help on determining the purpose of atable.
> > > particular field on a form.
> > >
> > > How can I get access to this information from my client application?
> > Check out the RDB$DESCRIPTION field in the RDB$RELATION_FIELDS system
> By the way, is there any syntax to fill the description field from within
> alter table add <column>-like statement?fields?
> Or any other "built-in" syntax to modify/read the various description
In addition to Thomasses answer about Firebird 2...
> I haven't seen applications that use, for example,Naah, not exactly. Pretty much ANY administration tool can use them.
> RDB$DATABASE.RDB$DESCRIPTION yet.
> It seems like those are "dead" or "legacy" fields.
For example, Database Workbench allows you to print the descriptions
when you're doing a database metadata printout. Could be very useful
for documentation purposes.
And it displays it as well -- useful when coding etc...
Database Workbench - development tool for Firebird and more!
Database development questions? Check the forum!