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 records in DBF File

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.


DOWNLOAD
for FREE

Updated Tue, 10 Nov 2026

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.

Download Free Trial Version
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