Fields list for a table?

[badukist]

Hi all
I want to do a code generator for triggers and I need to have all columns list for a table.
How can I get fields list for a table as in DBWorkbench or IbExpert?
I only need :
column_name,column_type,Length,Scale,Sub_type

Thanks

 

[MartijnTonies]

Hi,

This info is available in the system tables. RDB$RELATION_FIELDS and RDB$FIELDS hold the column info.

Good luck!

Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird, MySQL & MS SQL Server

http://www.upscene.com

 

[badukist]

Thanks and sorry for replying so late.
Works very well.