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.
>

Ann answered:

>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

Peter Ypenburg writes:

Does any one have a guide that I can use as a quick reference to what the
data in the above tables that Ann mentioned means. I have looked at them and
with some puzzling I am sure I will figure it out. It would be great to
check my thinking against documentation or code snippets.

Thank you.

Peter Ypenburg
AGM: Product Development
Barloworld Optimus
Tel +2711 286 1587 Fax +2711 286 1630 Cell +2782 789 9167
www.barloworldoptimus.com

Disclaimer

The information transmitted is the property of Barloworld Optimus Pty (Ltd)
and is intended only for the person or entity to which it is addressed and
may contain confidential and/or privileged material. Statements and opinions
expressed in this e-mail may not represent those of the company. Any review,
retransmission, dissemination and other use of, or taking of any action in
reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in error, please
contact the sender immediately and delete the material from any computer.