Hi,

I saw there is a RDB$DESCRIPTION field in RDB$RELATIONS table. This
field is used, for example, by IB_WISQL in the Desc tab.

The only way I see to assign a description to a table (or field or
domain) is to use DML, such as:

UPDATE RDB$RELATIONS
SET RDB$DESCRIPTION = "My description for this relation"
WHERE RDB$RELATION_NAME = "MY_TABLE"

, and even this leads to a "conversion error from string BLOB" error
message.

Question: Does a DDL statement exist which allow to assign a
description to a DB object? It would be very handy to put DB
documentation directly in the DB's creation script.

Fabrice Aeschbacher
mailto:fabrice.aeschbacher@...