How to Delete Records in a DBF File
Deleting and Recalling Records in DBF Viewer 2000®
To remove records found by a search in a specified field, click Edit | Delete Records - a dialog box opens.

Delete or Recall a Single Record
You may delete/recall a single record.
- To delete the record in dbf file, select it and select menu command Edit | Delete/Recall Record menu, or click the corresponding icon on the toolbar. The deleted record will be marked with the red sign.
- To restore the deleted record, select it and repeat the same action.
- To permanently remove all deleted records, click Edit | Pack.
Delete Duplicates and Empty Records
To delete duplicates, click Tools | Delete duplicates.
To delete empty records, click Tools | Delete empty records.
To recall deleted records, click Edit | Recall records.
To permanently remove record, click Edit | Remove record
Truncate or Clear the Whole File (Zap)
To delete all records starting from a selected record, select the record that you want to be the last one, and click Edit | Truncate. Confirm your choice. All records below the selected record will be permanently removed.
To clear the entire file, click Edit | Zap. All records will be removed.
Deleting via Command Line
"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" file.dbf /delete:First,Last | /delete /filter:file | [/LOG | /LOG:logfile]
Delete a Range of Records
"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" mybase.dbf /delete:1,100
Delete by Filter
"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" mybase.dbf /delete /filter:myfilter.txt
Delete by In-line Filter
"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" d:\base\mybase.dbf /delete /filter2:Name:Jim
Frequently Asked Questions About Deleting Records
What is the difference between Delete and Pack in a DBF file?
Delete only marks a record as deleted - it can still be recalled. Pack permanently removes all records marked as deleted.
Can I restore deleted records?
Yes, until the file is packed: select the record and repeat Delete/Recall, or use Edit | Recall records.
How do I delete all records at once ?
Use Edit | Zap - all records are removed from the file.
Can I delete by filter from the command line?
Yes. Use /delete with /filter or the in-line /filter2 option; examples are given above.
Windows 11/10/8/7
No credit card or e-mail address required.
See also: Export DBF to XLS, Export DBF to CSV, Export DBF to XML, Export DBF to SQL
Back to DBF Viewer 2000 Home