Hi,

>Ok, but is there any SQL DDL statement to fill in the description? I
>need to generate the database from an SQL script, so this would help.
>Of course, I can write "update rdb$relation_fields set
>rdb$description='lala' where ....", but this way description and
>documentation would not be together in the script - a potential
>source of errors (typos, forgotten description, ...)

Yes, you can put them into a script. Actually, the next version
of InterBase Workbench will extract it exactly like this if you're
using Firebird (because of the easy text-blob update).

(make note to self: support this :)

>Why does Firebird not support a COMMENT clause in CREATE TABLE?

Most probably because InterBase doesn't support it and no-one has
bothered to support it for version 1 - as that version was aimed
at bugfixing, not creating new features.


Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com