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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
