UPDATE (Upsert Form) - 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

Updates column values in a specified row and, if the row does not exist, inserts it into the table with a specified set of initial column values. The table must have a primary index and cannot be column partitioned.

For details on the temporal form, see Temporal Table Support.