WHERE Clause - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database

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.