DELETE

Delete rows from a table.

{
DELETE FROM table-name [ ]
[ WHERE ]
}

Description

This form is called a searched delete, removes all rows identified by the table name and WHERE clause.

Example

// Delete rows from the CUSTOMERS table where the CID is equal to 10.
DELETE FROM TRADE.CUSTOMERS WHERE CID = 10;

// Delete all rows from table T.
DELETE FROM T;

Related Topics