IBExpert has a DESCRIBE script command which does it - you can get a free
copy from hk-software.com/downloads

Alan

-----Original Message-----
From: David Ballantyne [mailto:david@...]
Sent: Thursday, 12 December 2002 3:20 PM
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



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/