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