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.


Regards,


Ann