01-08-2009 07:58 AM
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?
01-08-2009 02:08 PM
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.