On 22 Apr 2005 at 6:13, Adam wrote:

>We are doing some testing at the moment with a fair chunk of data. We
>need to empty a table containing lots of records. To make it even
>worse, there are 4 or 5 other tables that reference that table by a
>foreign key (on delete cascade), and nearly all of them have deletion
>triggers that will in turn update other tables.

The fastest way is: create script that drop all trigger and
constraint to this table, RECREATE the table and create constraints
and triggers back.
--
SY, Dimitry Sibiryakov.