Valid in: SQL, ESQL

The DELETE statement deletes rows from the specified table that satisfy the search_condition in the WHERE clause. If the WHERE clause is omitted, the statement deletes all rows in the table. The result is a valid but empty table.

If the WHERE clause includes a subselect, the tables specified in the subselect cannot include the table from which you are deleting rows.