michal.720 wrote:

> I searched the web, looked into my book... I cannot find how to add
> comment/description to table or column using CREATE TABLE "xxx" ....

It's not available in SQL, so it's not provided at that level :(

> The only way I know is to use IBExpert, which finaly creates ugly query
> like this one:
>
> update RDB$RELATION_FIELDS
> set RDB$DESCRIPTION = ?DESC
> where (RDB$RELATION_NAME = 'cmp_job_users') and
> (RDB$FIELD_NAME = 'job_id')

Yep - that is the way to do it. The client tools hide these from you,
but we are working at the same 'level' as client tools so have to use
the same 'tricks' !

> Is there any complete help / manual online for Firebird?

Quick answer NO :(
There is a lot of data on the websites, and linked back to the original
Interbase documents, but the most complete data is Helen's book, which
is not available on line. It IS worth the money, and has all of the
system table stuff at the back, but you can also find that in the
Interbase pdf's
( Where are they hidden now? )

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services