If you need to remove some data from a table in a relational database, you can use the SQL DELETE statement. This statement lets you specify which rows to delete based on certain criteria.

Creates a delete query that removes records from one or more of the tables listed in the FROM clause that satisfy the WHERE clause. DELETE is especially useful when you want to delete many records. To ...

The DELETE statement isn't supported for the Microsoft Excel or Text driver. The INSERT statement is supported for the Text driver.. The dBASE driver doesn't support packing a table to remove "deleted ...