Target Table Options
Syntax Element … |
Specifies … |
table_name_1 |
the name of the base table, queue table, or derived table to be updated, or the name of a view through which the table is accessed. If you specify a correlation name for table_name_1 in the FROM clause, then you must specify that correlation name for the updated table instead of table_name_1. |
correlation_name |
an alias for table_name_1. You cannot specify a correlation name for the table if the UPDATE statement includes the FROM clause. Correlation names are also referred to as range variables. The correlation_name option is a Teradata extension to the ANSI SQL:2011 standard. |