--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@...> wrote:

>
> Cicero wrote:
> > I'm developing an application that supose to be independent of RDBMS.
> > It's based on Oracle for now, and I use some views from Data

Dictionary.

> > How can I have views in FB more friendly like Oracle Data Dictionary
> > views (COL, ALL_CONSTRAINTS, ALL_CONS_COLUMNS, ALL_TAB_COLUMNS,
> > ALL_TABLES)?
> >
>
> Look at the system tables RDB$RELATIONS describes tables and views,
> RDB$RELATION_FIELDS describes the fields in tables, RDB$FIELDS describes
> domains, etc. You may want to declare views that organize that
> information in more familiar ways with familiar names.
>
>

I have port ALL_CONSTRAINTS, ALL_CONS_COLUMNS, ALL_TAB_COLUMNS,
ALL_TABLES, and others views for Fyracle (the Firebird Oracle-mode):
http://www.fyracle.org/downloads/catalog_views.zip
you will just have to remove parts using ORA$OBJECTS that is Fyracle
specific.

Regards
PAscal