Yes.. Truncate table <table name>;
This does not require a commit. Once truncated data cannot be rolled back so be careful when you use it. It is an immediate action. Truncate clears the what's commonly known as 'the high water mark' of a table in a database thus shrinking the size in case it was a huge table which in your case it definitely is.. Hope this helps.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Ex Soundgarden Sent: Wednesday, December 09, 2009 5:58 PM To: [email protected] Subject: Re: safest and fastest way to delete AR Email records ** Hi Axton, I'm not sure where David posted his reply from my question. When you say truncate table, this means that I would directly go to the db to delete records? ---------------------------------------------------------------------------- -- From: Axton <[email protected]> To: [email protected] Sent: Tue, December 8, 2009 7:06:37 PM Subject: Re: safest and fastest way to delete AR Email records ** Look into the sql 'truncate table' to empty it initially. David has posted what you need for the ongoing maintenance of the data. While doing the initial delete, you probably want to look at the email error logs form, the email attachments form, and all the other email forms. Axton On Tue, Dec 8, 2009 at 5:56 PM, Ex Soundgarden <[email protected]> wrote: ** Hi All, I've been wandering around searching for some tips on how to delete 3 million records sitting in AR System Email Messages form. What I''m doing right now is just doing it by batch - deleting 10,000 records every now and then. From the past, I remember doing it directly in the database by re-creating the Email Messages table (which eventually dropped all the records). I had no problem with this. I just want to know if there are other ways to delete the records without going directly to the db? Thanks, Gabud _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

