Peter Ypenburg wrote:

> Hi All,
>
> Has anybody written a SQL that will bring back the dependencies of data in
> the tables structure in a database.
>

Well, the engine has code for that purpose... not SQL yet, but similar.
The information is stored in the system tables and you may need to
look at several. RDB$DEPENDENCIES may be enough. If not, try combining
that with RDB$RELATION_CONSTRAINTS, RDB$CHECK_CONSTRAINTS, and
RDB$CHECK_CONSTRAINTS. Browsing through those tables should give you
enough hints to start...

Regards,


Ann