Delete information massively

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Hello,

I would like to eliminate all the data from the accounts, target clients and contacts in a massive way and every time I select all the blank screen is placed due to the large amount.

I would like to do it through the database but I do not know in which tables this information is stored, so I would appreciate it if you would provide me with this information.

regards

2

The database table names are quite self-explanatory:


accounts
contacts

The exception is Targets which have a different name in the database, for historic reasons:

prospects
prospect_lists

If you use custom fields, you will also find a table for each module with those:


accounts_cstm
contacts_cstm
etc.

Then you have the relationship tables, like:


accounts_contacts

A good trick to find out where you have lots of data is the SQL query I give at the top of this article:

https://pgorod.github.io/Database-tables-size/