db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Silvio Godenzi <gode...@masterpoint.com>
Subject Re: [J2] Vote: Torque schema generation problems - how to proceed?
Date Thu, 09 Dec 2004 16:28:57 GMT
Hi,

dropping everything in reverse order than it was created should
avoid referential integrity violations.

BTW: I posted this already in march 2002

Regards,
Silvio

> To change this, we would have to change the loop to
>
> for (all tables in db)
>  drop constraints (if external)
>
> for (all tables in db)
>  drop tables
>
> (these two probably optional
>
> for (all tables in db)
>  create tables
>
> for (all tables in db)
>  create foreign and primary keys (if external)
>
> Bigger problem would be tables that have foreign key relations. In
> that case, we would need to reorder the table sequence so that no
> foreign key violations happen.
>
>  
>


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message