Empty Tables (2000)

Topic

New Reply

Is there a way of emptying the table quickly, I basically want to flush all the data out and start a fresh?

Reply | Quote

Replies

Take hold of a corner of the table cloth, and pull sharply.

You can create a delete query to delete all records in a table.
If you want to remove the records from several tables, create a delete query for each. If you wish, you can create a VBA procedure or a macro that executes the delete queries.

Note: if you have relationships with enforced referential integrity, you must take the following into consideration:
– If you have specified Cascade Delete Related Records for a relationship, you don’t need a delete query for the table on the “many” side. When you delete records from the “one” side, the related records on the “many” side will automatically be deleted too.
– If you have NOT specified Cascade Delete Related Records for a relationship, you must run the delete query for the table on the “many” side first, then the delete query for the table on the “one” side. The latter will fail if you try to run it first.

Reply | Quote

I just open the table from the database window, then hit Ctrl-A and the delete key. HansV’s comments about Cascaded Deletes apply to this method as well.

Reply | Quote