Hi,

I need to get a list of all the dependencies for each object in the
database.

I have been able to get a lot of dependencies out of RDB$DEPENDENCIES
but I've noticed it does not list the dependencies between tables
(i.e. the referential constraints).

This is something I absolutely need to know but I'm not quite sure
how to get this information as RDB$REF_CONSTRAINTS doesn't seem to
store everything I need to know? The info I need is:

DEPENDENT_TABLE, DEPENDED_ON_TABLE, DEPENDED_ON_FIELD

Can anyone please tell me what sql I need to get this info?

Also, can anyone tell me if there are any other dependencies I could
be missing other than the ones listed in RDB$DEPENDENCIES and the
ref. integ. contraints?

Thank you,
Ben Daniel