DELETE SQL Command
Marks records as deleted. It's similar to Delete Record from DBF file command from Edit menu. You can restore those records by using the Recall Record command.
Records marked as deleted physically removes from the DBF file when the PACK command is executed. See it's description below.
[WHERE FilterCondition1 [AND | OR FilterCondition2 ...]]
Specifies the name of the DBF file for deleting records. If Table_List contains file name only (without path), this DBF file is being looked at the same directory, from where the last DBF file was opened.
If the table hasn't been opened, DBF Commander opens the file automatically. It remains open after the query is complete.
JOIN clause allows you to specify one or more secondary tables. For more information, please see SELECT SQL statement topic.
Specifies one or more filter conditions that records must meet to be deleted. Number of filter conditions is not limited.
Removes all records marked for deletion permanently.
Specifies the name of the DBF file to pack.