--- In firebird-support@yahoogroups.com, "legrand_legrand_63"
<grand.brun.63@...> wrote:

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

Ok. Thanks. I'll look into it.


Cicero