17.10 - DELETE Syntax Elements (ANSI Valid-Time Table Form) - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - ANSI Temporal Table Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1186-171K
Language
English (United States)
valid_time_table
The valid-time table from which you are deleting rows.
FOR PORTION OF
Qualifies rows for deletion that have valid-time periods that are within or that overlap the period defined by point_in_time_1 and point_in_time_2.
valid_time_period_name
The name of the valid-time derived period column. This is not “VALIDTIME.” It is the name assigned to the derived period column when the table was defined.
point_in_time_1
point_in_time_2
Delimits the period of applicability of the deletion.

A date or timestamp expression that can be a constant, scalar UDF, scalar subquery, or business calendar function that evaluates to a DATE or TIMESTAMP[(n)] [WITH TIME ZONE] value.

The expression can be any expression, including parameterized values and built-in functions such as CURRENT_DATE, CURRENT_TIMESTAMP, TEMPORAL_DATE, or TEMPORAL TIMESTAMP. The expression cannot reference any columns, but it can be a self-contained noncorrelated scalar subquery.

WHERE search_condition
For information on the this syntax and other nontemporal keywords, clauses, and options for DELETE, see Teradata Vantage™ - SQL Data Manipulation Language, B035-1146.