Subject Re: [firebird-support] Retrieve fieldnames AND types
Author W O
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 <m.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
> >
> >
> >
>
>
>


[Non-text portions of this message have been removed]