|
|
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
Navigation:
[Reply to this message]
|