TRUNCATE TABLE Calls
only takes a few seconds and its totally empty
----- Original Message -----
From: "Brian Johnson" <email@example.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...
> 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
> minutes max.
> Brian 8^)
> For more information about this list (including removal) go to:
For more information about this list (including removal) go to: