Re: Trim Call records

Robert Boyle ( robert@garden.net )
Sun, 14 Jun 1998 13:41:01 -0400

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Kelly Wright: "Trim Call records"
Next message: Jorge Pocaterra: "5:Invalid procedure call"

At 07:05 AM 6/14/98 -0400, you wrote:
>
> How do you trim the call records in emerald. I have tried the script and
> still have 400k lines that is taking up 115Meg of space.
>
> Is there some command that will dump all the records? I need to recover
some
> space.

To delete selectively,

DELETE FROM Calls WHERE CallDate < 'June 1 1998'

To delete EVERYTHING

TRUNCATE TABLE Calls

-Robert

Robert Boyle Server Co-location,
Garden Networks Internet Access,
50 Diller Ave Development & Consulting
Newton, NJ 07860 (973)300-9211 Ext.103
8AM-8PM Mon-Fri EST http://www.garden.net
Lucent RABU & Software.Com Post.Office VAR

Previous message: Kelly Wright: "Trim Call records"
Next message: Jorge Pocaterra: "5:Invalid procedure call"