Showing results for 
Search instead for 
Do you mean 

How to delete all data in the table

New Member
Posts: 2
Country: United States

How to delete all data in the table

First of all I want to appologize for joining this forum and instantly posting a question, but I am pretty lost at the moment.


We currently have 700,000 records in our database and we are wanting to delete all of the data in the main table.


I can do a select all (ctrl + a)  and right click and do delete, but that crashes after it deletes about 5,000 rows of data.



Is there anything I can do to delete more data at the same time?

Copper Elite Contributor
Posts: 159
Country: Brazil

Re: How to delete all data in the table

Hello Linda,


If I were you I would "create an empty copy of" your database !

This will preserve database structure with no data at all.

I hope this helps.

Mac, Jorge A. Mac Genity
Using ACT! by Sage 2013 Pro Version, on Windows 7
Intel Core I7-2600 CPU @ 3,40 GHz
12,0 GB - 64 bits - NVidia GForce GTX 360 SE