Posted by Razvan Socol on 12/16/05 09:31

Hi,

You can do one of these:

a)
1. Drop all the FK-s
2. Truncate the tables (in any order)
3. Re-create the FK-s

b)
1. Delete the tables (in a particular order, so FK-s won't be
violated).

Of course, DELETE is slower than TRUNCATE, but if there are many FK-s
and not too much data, I preffer not to drop the FK-s.

Razvan

[Back to original message]