[firebird-support] Retrieve fieldnames AND types

[Michael Vilhelmsen]

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