Deleting batches of records
You can delete multiple records of a specific entity or link type by using Batch Delete.
About this task
- All records.
- All the records in a particular set (the set itself is not deleted).
- All the records of the specific type that are found by a particular query.
If soft delete is enabled on your database, then deleted records can be restored if necessary, that is until a purge operation makes the deletion permanent.
- Select .
- Select the entity or link type of the records that you want to delete.
- In the Source area, specify the source of the specified entity or link type records.
- Click Delete.
Tip: To cancel the delete, press Esc. The delete stops and a message displays how many records have already been deleted. The behavior when canceling a batch delete is different depending on the type of database you are using and the Audit Level set:
If you are deleting a large number of records the deletion can take a while to complete. When the deletion completes, you are shown the number of records that have been deleted.
Database type and Audit level Behavior when canceling delete SQL Server - 1,2, or 3 No records are deleted. SQL Server - 4 or 5 Records up to the point when the batch delete is canceled are deleted. Microsoft Access - Any Records up to the point when the batch delete is canceled are deleted.