Good practice is using a data dictionary instead of commenting columns/tables directly. Firebird does not have a built-in data dictionary (neither does SQL Server/Oracle).

--- In firebird-support@yahoogroups.com, "pechmann0406" <pechmann0406@...> wrote:
>
> Hello Helen,
> thanks a lot for your answer.
>
> Is it considered good practice to use COMMENT directly after the CREAT TABLE statement in one script file ?
>
> Kind regards,
> Ralf.
>
> --- In firebird-support@yahoogroups.com, Helen Borrie <helebor@> wrote:
> >
> > At 10:12 PM 13/07/2010, pechmann0406 wrote:
> > >Hello all,
> > >I found very little information about this, so I dare to ask.
> > >
> > >I'm generating my databases and tables with SQL-scripts, which works fine.
> > >
> > >Now I wonder if I could set the field descriptions (for better documentation) with the script too.
> > >
> > >Has anybody some information for me if this is possible and how it could be done ?
> > >(Working with firebird 2.1.3 on win32)
> >
> > Use COMMENT ON COLUMN statements, e.g.,
> > COMMENT ON COLUMN atable.acolumn IS 'I wish to comment on this column';
> > The description is stored in a text blob.
> >
> > ./heLen
> >
>