Subject Determining the dependencies of data in a Firebird database
Author Peter Ypenburg
Hi All,

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

We want to write a program that exports some of the data in a database into
SQL insert statements into a empty database. The order of the insert
statements when we run them on the empty database is important in the sense
of the data dependencies of foreign keys and so forth. Instead of hard
coding the dependencies in our export for the database in it's current
state, we would like to write something that will always do the export in
the order of the data dependencies even if new tables are added.

Hope someone can help with a easy solution.

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


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.