thank you Martijn
--- In firebird-support@yahoogroups.com, "Martijn Tonies" wrote: > > 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 > > > > > > >