Subject ODP: [firebird-support] Listing Table of Database in Order of Dependency
Author liviuslivius
hi,

why you need this?
i ask because it smells me wrong direction of doing something.

regards,
Karol Bieniaszewski



-------- Oryginalna wiadomość --------
Od: "LtColRDSChauhan rdsc1964@... [firebird-support]" <firebird-support@yahoogroups.com>
Data: 25.03.2016 11:36 (GMT+01:00)
Do: firebird-support@yahoogroups.com
Temat: [firebird-support] Listing Table of Database in Order of Dependency

 

Hi,

How can i list tables of a database in order of dependency ie

TABLE_1 (no foreign key references)

TABLE_2 (foreign key references, if any, in TABLE_1 )

TABLE_3 (foreign key references, if any, in TABLE_1 / TABLE_2 )

TABLE_4 (foreign key references, if any, in TABLE_1 / TABLE_2 / TABLE_3)

....

Thanks and Regards,

Rajiv