Subject Re: How to set field descriptions
Author pechmann0406
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,

--- In, 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