TRUNCATE TABLE Calls
only takes a few seconds and its totally empty
----- Original Message -----
From: "Brian Johnson" <brianj@nvc.net>
To: <emerald@iea-software.com>
Sent: Wednesday, July 19, 2000 4:35 PM
Subject: [Emerald] Calls Table Dump
> I want to completely empty my calls table.
>
> I have run the following script, but It keeps timing out...
>
> Delete
> From Calls
> Where CallDate < '6-1-2000 00:00:00'
>
> The table has more than 2,000,000 records.
>
> I am looking for a quick way to dump the entire table. By quick I mean A
few
> minutes max.
>
> Brian 8^)
>
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart