AnsweredAssumed Answered

How do I best delete bulk records in 7.2 Professional?

Question asked by sonesay inthavong on Jul 8, 2014
Latest reply on Jul 9, 2014 by sonesay inthavong
We've been doing some testing of importing of Accounts, Contacts, and Leads into our SugarCRM install. We need to do a hard delete on all records we imported plus any related data (I do not know what this covers)

It would be nice to have a near clean working database again with nothing we imported. Has anyone had this requirement and have a good solution to the problem?


I've used the sql below but is it enough?

# Removing leads import
TRUNCATE TABLE leads;
TRUNCATE TABLE leads_audit;
TRUNCATE TABLE leads_cstm;
TRUNCATE TABLE prospect_lists_prospects;

# Removing Contacts import
TRUNCATE TABLE contacts;
TRUNCATE TABLE contacts_audit;
TRUNCATE TABLE contacts_bugs;
TRUNCATE TABLE contacts_cases;
TRUNCATE TABLE contacts_cstm;
TRUNCATE TABLE contacts_users;

I would like to be able to remove as much junk as possible without breaking anything.

Outcomes