DELETE example

The following example deletes all the rows in a DBF table called CUSTOMER and results in a table with zero rows:

DELETE FROM CUSTOMER.DBF

The following example marks all the rows in a DBF table called CUSTOMER for deletion, but does not actually delete the rows from the table:

DELETE FROM CUSTOMER.DBF WHERE CUSTOMER_N > 0

The following example marks all the rows where the CITY field is equal to "Freeport" for deletion in a DBF table called CUSTOMER:

DELETE FROM CUSTOMER.DBF WHERE CITY = "Freeport"

The following example deletes all the rows where the CITY field is equal to "Freeport" in a Paradox table called CUSTOMER:

DELETE FROM CUSTOMER.DB WHERE CITY = "Freeport"