Hi

I have found the way to retrieve fieldnames to a table via SQL.
Like this:

select
RDB$FIELD_NAME
from
RDB$RELATION_FIELDS
Where
RDB$Relation_Name='MYTABLE'


But I could use the SQL to ALSO retrieve the field type, but I am not sure where to find this information

COuld someone provide me with proper SQL?

Regards
Mcahel