Subject Re: [firebird-support] Getting access to column description info
Author Martijn Tonies
> > > I would like to use the data dictionary information in my database,
> > > particularly the Description information, for columns to be displayed
> > > users when they ask for further help on determining the purpose of a
> > > 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?
> 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,
> It seems like those are "dead" or "legacy" fields.

Naah, not exactly. Pretty much ANY administration tool can use them.

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...

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
My thoughts:
Database development questions? Check the forum!