Truncate the table is the simplest way.
-----Original Message----- From: Patel, Kamlesh <[EMAIL PROTECTED]> To: [email protected] Sent: Tue, 18 Sep 2007 3:46 pm Subject: delete mass amount of records from ARS 5.1.2 ** All, I am going through an upgrade plan to 7.x. ?Before I begin my upgrade I would like to remove lots of data records form our remedy forms.? I have a pretty good idea about remedy 5.1.2 patch 1375 data structure.? I would like to find out if there is alternative safe and fast way to remove up to 1,000,000 records from couple of remedy forms.? Most other forms are relatively small but I would like to employ a fast delete operation to minimize the outage period. ? Thank You ? Kamlesh Patel ? __20060125_______________________This posting was submitted with HTML in it___ ________________________________________________________________________ Email and AIM finally together. You've gotta check out free AOL Mail! - http://mail.aol.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
