Re: [firebird-support] Listing Table of Database in Order of Dependency

2016-03-29 Thread LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
On Mon, Mar 28, 2016 at 11:21 PM, setysvar setys...@gmail.com [firebird-support] wrote: > > > >Hi, > > Hi Rajiv! > > >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 (forei

Re: [firebird-support] Listing Table of Database in Order of Dependency

2016-03-28 Thread setysvar setys...@gmail.com [firebird-support]
>Hi, Hi Rajiv! >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

Re: [firebird-support] Listing Table of Database in Order of Dependency

2016-03-25 Thread LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
On Fri, Mar 25, 2016 at 7:07 PM, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > > > hi, > > why you need this? > I have been updating a deployed application of mine for last 8 yrs. The database has changed from some 30 tables to 80 tables. To migrate data (i have a .NET app