Delphi Database, Delphi Components from ComponentAce
Products Download Order Contact us
DELETE Command
Previous  Top  Next



A DELETE statement is used to remove specified records from a table. It can also be used to remove all records.

Syntax

DELETE FROM [ MEMORY ] table_name [ WHERE condition ]

Description

DELETE deletes rows that satisfy the WHERE clause from the specified table. If the WHERE clause is absent, the effect is to delete all rows in the table. The result is a valid, but empty table.

MEMORY
If MEMORY keyword is specified before the table_name then an in-memory table is referenced, not a disk one.  

table_name
The name of an existing table.  

condition
An expression that returns a value of type boolean. Only rows for which this expression returns true will be deleted.  

Example:

DELETE FROM developers WHERE name = 'Bob'  
        © 2003 - 2024 ComponentAce  | .net zip component | barcode for .net | delphi zip component | delphi database Mar 29, 2024