WHERE Clause
Syntax Element … |
Specifies … |
condition |
a predicate to filter the list of rows to be deleted. The expression operands can be either constants or references to fields in the specified table or other tables. The predicate also can specify a scalar subquery. See “Scalar Subqueries” on page 124 and “Rules for Using Scalar Subqueries in a DELETE Statement” on page 328 for details. |
ALL |
that all rows in the table are to be deleted. This is the default and is used when a WHERE condition is not specified. The ALL option is a non-ANSI Teradata extension. |