15.12 - Updating Table Rows using an UPDATE Template - Teradata Studio

Teradata Studio Express User Guide

prodname
Teradata Studio
vrm_release
15.12
created_date
August 2016
category
User Guide
featnum
B035-2042-086K
You can generate an UPDATE statement template in the SQL Editor to update table rows.
  1. Click Query Development to open the Query Development perspective.
  2. Open the Data Source Explorer and navigate to the database table in which you want to delete rows.
  3. Right-click the table object and select one of these options:
    For Select
    Teradata Database Teradata > Generate SQL > UPDATE Statement
    Aster Database Aster > Generate SQL > UPDATE Statement
  4. In the SQL Editor, review the generated UPDATE statement and optionally add conditions to the WHERE clause to update rows.
  5. Click to execute the UPDATE statement and update the row in the table.