WHERE Clause - Teradata Database - Teradata Vantage NewSQL Engine
SQL Data Manipulation Language
- Product
- Teradata Database
- Teradata Vantage NewSQL Engine
- Release Number
- 16.20
- Published
- March 2019
- Language
- English (United States)
- Last Update
- 2019-05-03
- dita:mapPath
- fbo1512081269404.ditamap
- dita:ditavalPath
- TD_DBS_16_20_Update1.ditaval
- dita:id
- B035-1146
- lifecycle
- previous
- Product Category
- Teradata Vantage™
-
condition
- 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 and Rules for Using Scalar Subqueries in a DELETE Statement for details.
- ALL
- 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.