Update Table Rows using an UPDATE Template | Teradata Studio/Studio Express - Updating Table Rows using an UPDATE Template - Teradata Studio

Teradata® Studio™ Express User Guide

Product
Teradata Studio
Release Number
20.00
Publication Date
October 2023
Content Type
User Guide
Publication ID
B035-2042-103K
ft:locale
en-US
ft:lastEdition
2026-10-23
dita:mapPath
zpv1696897581767.ditamap
dita:ditavalPath
ft:empty
ft:sourceId
dita
dita:id
wsb1469630620005
  1. In the Data Source Explorer, navigate to the database table in which you want to delete rows.
  2. Right-click the table object and select one of these options:
    For Select
    Teradata Teradata > Generate SQL > UPDATE Statement
    Aster Database Aster > Generate SQL > UPDATE Statement
  3. In the SQL Editor, review the generated UPDATE statement and optionally add conditions to the WHERE clause to update rows.
  4. Click "" to execute the UPDATE statement and update the row in the table.