Hi, I am new to this group, but hopefully someone
will be able to point me in the right direction.

I'd like to be able to determine the column
types for each column of a table. (I think) I am
after a correspondence similar to:
column1Name => VARCHAR(7)
column2Name => INTEGER PRIMARY KEY
and so on.

I've looked through all the tables mentioned at
http://discuss.joelonsoftware.com/default.asp?design.4.281633.7
and I can get all the table columns (headers) from
rdb$relation_fields.rdb$field_name =
rdb$relations.rdb$relation_name

but I don't see where I get the type.
Can someone please advise me where I can get
ahold of the column definitions?

Thanks,
Csaba Gabor from Vienna

Background. I'm using PHP 5.2 on Windows Vista
to export data from a semi extensive Firefird 2.1
database (about 100 tables, taking up 2 GB). I
am able to query all the tables as desired, and
it is this last piece of information I'd like to
fill in on an automated basis. The export is not
a one time only thing, and will involve repeated
passes, as it has not yet been decided what data
will actually be exported. I'm familiar with
SQLite and MySQL, but I am new to Firebird.