|Subject||Re: Data Dictionary|
--- In email@example.com, "legrand_legrand_63"
> --- In firstname.lastname@example.org, "Ann W. Harrison"
> <aharrison@> wrote:
> > Cicero wrote:
> > > I'm developing an application that supose to be independent of
> > > It's based on Oracle for now, and I use some views from Datadescribes
> > > 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
> > domains, etc. You may want to declare views that organize thatOk. Thanks. I'll look into it.
> > 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):
> you will just have to remove parts using ORA$OBJECTS that is Fyracle