On Thu, Jan 23, 2003 at 08:32:34 -0800,
eric <e(dot)pellegrom(at)lectric(dot)nl> wrote:
> Hi,
>
> A change in this version is:
> "Disallow TRUNCATE on tables that are involved in referential
> constraints (Rod)"
>
> but i've a table witdh a many of referential constraints, what is now
> the best way to empy a table?
The simplest way is:
delete from table-name;
If you have a very large table this might be to slow.
Another option would be to drop the contraints and then truncate the
table.