If I understand you question, you need to import desriptions of your
metadata from external source. Check the system tables sturcture. You can
find columns named RDB$DESCRIPTION type BLOB in the system table, which
hold the metadata description.

try
SELECT RDB$RELATION_NAME, RDB$DESCRIPTION
FROM RDB$RELATIONS

or
SELECT RDB$FIELD_NAME, RDB$DESCRIPTION
FROM RDB$RELATION_FIELDS

and you will see the description inserted by the tools. I guess you can try
to update the RDB$DESCRIPTION via script.

Ales

> -----Original Message-----
> From: David Ballantyne [mailto:david@...]
> Sent: Thursday, December 12, 2002 5:20 AM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Metadata Descriptors/Comments
>
>
> Hi gang and greetings from way Down Under;
>
> Firstly let me appologise if this message is posted a couple
> of times, as I
> am having a horrid time getting my message to get throgh to the list.
>
> My name is David Ballantyne, and I have just been empowered
> with converting
> out existing large R:Base database to Firebird. I have been
> playing with
> Firebird for the past month or so and have had great sucess with this
> wonderful OS product (keep up the good work team!). I have
> only joined the
> list in the past 48 hours, and so must confess, that this is
> my very first
> post.
>
> I am a Senior Business Analyst / Software Designer and have
> been using RDBMS
> systems of various flavors for many years, but am a rank
> "newbie" to the
> Firebird world. I have sucessfully ported the entire 380
> table / 302 view
> structure and written scripts to push all of our default
> corporate data to
> the Firebird backend.
>
> All good so far - with only one small dilemma. To date, I
> have not been
> able to find (and maybe I didn't look well enough) any
> interface (SQL, API
> etc) which will allow me to port the metadata descriptions
> (table comments,
> column comments, view comments etc).
>
> I know it must be there somewhere as I have the ability to
> manually enter
> these descriptors through any of the various flavoured DB admistration
> tools. If someone could pleeease point me in the right
> direction of where
> to find such SQL command or API call, It would be greatly appreciated.
>
> Thanking you in anticipation and...
>
> Kindest Regards
>
>
> David Ballantyne
> Senior Analyst
> Just For You Software
> Sydney, Australia
>
> Ph: 61+2 9552 3311
> david@...
> http://www.just4usoftware.com.au
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Get 128 Bit SSL Encryption!
> http://us.click.yahoo.com/CBxunD/vN2EAA/xGHJAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
> 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/
>
>