Subject | Dependencies |
---|---|
Author | ben_daniel81 |
Post date | 2003-10-21T07:37:28Z |
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
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