Subject RE: [firebird-support] How to set object description
Author Thomas Steinmaurer
> I couldn't find sql command for setting up a table description (or
> comment). Is it only possible via update on
> rdb$relations.rdb$description or is there some special sql for this?

There isn't a DDL statement for that. You have to update the
mentioned column in RDB$RELATIONS directly. If you are using
Firebird (you do, right?), then it's pretty simple, because
you can assign a string to a BLOB column directly.

Most of the available third-party tools are capable to do
that as well, so you don't have to fiddle around with
system tables then.


HTH,
Thomas Steinmaurer
LogManager Serie - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com