Yes, that far I got.

My main problem is:

* Lack of documentation. For a lof of the sutff I am pretty lost.
* Where the heck is a list of all TABLES? I can find fields, relations,
but no RDB$ table that contains the TABLES themseves.

Thomas

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Adam
> Sent: Sonntag, 26. Juni 2005 08:05
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Re: Schema query? Need help to
> get started.
>
> --- In firebird-support@yahoogroups.com, "Thomas Tomiczek"
> <t.tomiczek@t...> wrote:
> > Hi,
> >
> > I am totally lost in the firebird documentation. Is there anything
> > regarding schema queries?
> >
> > We basically need to port a generic data access layer, including
> > database schema syhcnhronization, to firebird. I need to find, in a
> > given database:
> >
> > * The tables
> > * The fields in the tables
> > * The indices
> > * The relations
> >
> > There seem t obe tables for everything (except tables), but
> I do not
> > find documentation.
> >
> > Can someone point me to the correct locations?
> >
>
> Hi Thomas,
>
> The system tables all start with RDB$. Start with
> RDB$RELATIONS and work your way from there. Some of them are
> obvious, some of them will require you to work out which
> field is a flag. All of the GUI tools need to work from these
> tables, so the information is all there.
>
> Adam
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net 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
>
>
>
>
>
>
>
>