> Hi there,
>
> The metadata of a table includes a "description" field for every field
> of the table.
>
> Now I wonder how do I fill in that metadata field, for instance when
> creating a domain:
>
> CREATE DOMAIN DCREATED AS
> TIMESTAMP
> DEFAULT current_timestamp
> NOT NULL
> DESCRIPTION 'Datetime of creation'
>
> or perhaps when adding a field to a table:
>
> ALTER TABLE CUSTOMERS
> ADD CREATED DCREATED
> DESCRIPTION 'Datetime of creation'
>
> In the two examples above, the last line is invalid. So, how do I do this?
>
> Thanks in advance,
>
> -Benton
>

AFAIK - only the 3rd party tools like IBExpert, etc will create a
description script for you. It's a system table update, not part of the DDL
definition for the table unfortunately.
Alan