Fabrice,

Currently, it is not possible to add descriptions as part of the CREATE
TABLE... syntax.

A feature request was previously logged for this item. At this time,
there is no timeframe for the implementation of same (do you want to
volunteer?).


Sean

-----Original Message-----
From: fabrice.aeschbacher@...
[mailto:fabrice.aeschbacher@...]
Sent: Wednesday, February 28, 2001 5:13 AM
To: ib-support@yahoogroups.com
Subject: [ib-support] Metadata description


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@...



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/