How to: Remove Deleted Records
After marking records for deletion, you can remove them permanently from disk.
To remove marked records from disk
Open the table in a browse window.
On the Table menu, click Remove Deleted Records.
When prompted to confirm deletion, click Yes.
The marked records are removed from disk, and the browse window closes.
To remove marked records from disk programmatically
Use the PACK command
For more information, see.
PACK has two clauses: MEMO and DBF. Calling PACK without the MEMO or DBF clauses removes records marked for deletion in the table (.dbf) file and the associated memo (.fpt) file. When you call the PACK command, make sure the table has been opened exclusively. To delete records in the table file only and leave the memo file untouched, use PACK DBF. To remove unused space in the memo file without removing records marked for deletion in the table file, use PACK MEMO.