Martijn, can you send that presentation to me, too? I'm very interested.
Greetings. Walter. On Thu, Feb 14, 2013 at 8:19 AM, Martijn Tonies <[email protected]>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 > > > > > > > > > [Non-text portions of this message have been removed] ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
