Honest, I have checked the docs for this :o)

I want to add a comment to a table and its columns. You know
the thing, a description of the table which is stored in the database,
and descriptions of the columns etc.

IB Expert (nice bit of kit) uses the DESCRIBE command in its
own scripts to add a table or column comment. It seems to do column
comments by directly updating the RDB$DESCRIPTION column of
RDB$RELATION_FIELDS
table and table descriptions by directly updating the RDB$DESCRIPTION column
of the
RDB$RELATION table.

I'm a bit hesitant to update the system tables directly
(being of an Oracle background, this is a big no no !) but I'm unable to
find a
command that will allow me to add my descriptions.

The problem I'm having is that when I use IB_SQL to run
scripts etc, the IB Expert manner of using the DESCRIBE command is flagged
as an
error. I'm unable to find a DESCRIBE command so I presume this is just
something that IB Expert does itself.

Cheers,
Norman.

-------------------------------------
Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar@...
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

This email is intended only for the use of the addressees named above and may be confidential or legally privileged. If you are not an addressee you must not read it and must not use any information contained in it, nor copy it, nor inform any person other than Lynx Financial Systems or the addressees of its existence or contents. If you have received this email and are not a named addressee, please delete it and notify the Lynx Financial Systems IT Department on 0113 2892990.