EasyTable: Single-File Embedded Database,
a BDE replacement for Delphi and C++Builder



DELETE Statement
Previous  Top  Next


Introduction

The DELETE statement is used to delete one or more rows of data from a table.

Syntax

DELETE
FROM [MEMORY] table_reference [PASSWORD 'password_string']
[WHERE predicates]

MEMORY option specifies that in-memory table will be created.
The FROM clause specifies the table to use for the DELETE statement. The syntax is as follows:
FROM table_reference

The WHERE clause specifies filtering conditions for the UPDATE statement. The syntax is as follows:

WHERE predicates

Use a WHERE clause to update only records that meets specified conditions.

Here is an example

DELETE FROM Members WHERE ID >= 3


© AidAim Software EasyTable: Easytable Bde Alternative Single File Delphi Databas