At 02:38 PM 16-05-02 -0400, Brandon Fouts wrote:

>I am wanting to find the order/relations between the tables in a database
>that I am using. For instance, if i have three tables: table 1, table 2 and
>table 3 and the order that data should be inserted is table 2 then table 1
>then table 3 to ensure referential integrity and so I don't violate foreign
>key constraints. Is there a SQL statement, delphi component, etc. that
>could give me this order. The reason being is that I have about 200 tables
>that I need to know the exact order/relational order of the tables for
>database repair. I didn't design the db so therefore I don't know this
>order. The other thing is I don't really want to have to go through
>manually figuring this out.

Try IBUtils, a nifty little free graphical tool from Ales Kahanek:

http://www.alikiwi.com/ibutils/ibutils.htm

cheers,
Helen


All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________