Develop a script to truncate table <table name>; for all foundation data T, H and B tables and reset ther corresponding nextid values to 1. That would be the fastest way.
Going to each form and deleting would amount to requesting delete action through the AR System API layer and would not be the fastest way. Joe ________________________________ From: Raj <ravi6...@gmail.com> To: arslist@ARSLIST.ORG Sent: Thursday, August 20, 2009 1:21:01 PM Subject: Apt. way to delete foundation data Hello all, Last month, I did foundation data uploads using ARImport tool. Leter I realized that using DMT for this is the best method. So I want to clean up the data which i did imports through Import tool. which is the best way to delete foundation data, is there any utility/ tool or should I just go to each forms and do the clean up? Is there any faster way ? please advise, Raj __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"