Subject Re: [firebird-support] How to set field descriptions
Author Helen Borrie
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