Subject | RE: [firebird-support] How to set object description |
---|---|
Author | Thomas Steinmaurer |
Post date | 2004-02-15T15:08:36Z |
> I couldn't find sql command for setting up a table description (orThere isn't a DDL statement for that. You have to update the
> comment). Is it only possible via update on
> rdb$relations.rdb$description or is there some special sql for this?
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