Hi Ed,

> is there an easy way to include table/field descriptions when
> building a DB via a script? Also (any maybe I need to ask this in the
> IBO group) is there an easy way of getting table/field descriptions
> when viewing a database (verses having to go fetch it from the
> RDB$... tables).

With Firebird, you can do direct system table updates like
this:

UPDATE RDB$RELATIONS SET RDB$DESCRIPTION =
'My Description' WHERE RDB$RELATION_NAME = 'MY_TABLE'

And so on.

Database Workbench extracts these for you.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com