Subject Dependencies
Author ben_daniel81
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 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?

Thank you,
Ben Daniel