Hello Michael,

I'll send you one of my old presentations about the system tables.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

> 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
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>