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