UPDATE - Teradata Database

Modifies column values in existing rows of a table.

The UPDATE statement can take the following forms:

Basic - updates one or more rows from a table.

The Basic form can be specified with or without a FROM clause.

Basic for Joined Tables

The Join Condition form updates rows from a table when the WHERE condition directly references columns in tables other than the one from which rows are to be updated; that is, if the WHERE condition includes a subquery or references a derived table.

Positioned - see “UPDATE (Positioned Form)” in SQL Stored Procedures and Embedded SQL.

Temporal - see ANSI Temporal Table Support and Temporal Table Support.

Upsert - see “UPDATE (Upsert Form)” on page 495.