The easiest way for you is to exploit the SET FOREIGN_KEY_CHECKS property. I know this is supported by MySQL for sure. And something similar if not the same, should be available with other databases too.
SET FOREIGN_KEY_CHECKS=0; //script generated SET FOREIGN_KEY_CHECKS=1; Remember to set it to 1 at the end of your script, otherwise foreign key constraints would not be in place when you later start "operating" on the database. HTH, Raghu On 1/20/06, Ashish Kulkarni <[EMAIL PROTECTED]> wrote: > > Hi > there is a export tool, but the problem it creates DDL > sorted by table names, and it does not take into > account any database relationships, i may have to go > in manually and creates script.. > for example there may be a table ABC which has a > foreign key constraint with table XYZ. > This database utility created DDL for ABC first and > then for XYZ. > So i run these DDL statements it gives error saying > that table XYZ is not created. > So i need some utility which will create DDL > considering these constraints > > Ashish > > > --- [EMAIL PROTECTED] wrote: > > > Doesn't your database include such an export tool? > > What database are > > you using? > > > > Ashish Kulkarni inquired > > > Is there any open source utility which i can use > > to > > > create DDL from an existing database, so i can use > > it > > > to run to create tables on other database. > > > This utility should be smart enough to create DDL > > > statements for tables with primary key, before > > tables > > > with foreign key. > > > That way when i run the DDL to create tables on > > other > > > database there wont be referential integrity > > errors. > > > Is there some thing like this out in market. > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > For additional commands, e-mail: > > [EMAIL PROTECTED] > > > > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
