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 > > >