Delete Table Rows using a DELETE Template | Teradata Studio/Studio Express - Deleting Table Rows using a DELETE Template - Teradata Studio

Teradata® Studio™ User Guide - 17.20

Product
Teradata Studio
Release Number
17.20
Published
September 2022
Language
English (United States)
Last Update
2022-09-23
dita:mapPath
gvw1648839236371.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
Product Category
Teradata Tools and Utilities
  1. In the Data Source Explorer, navigate to the Vantage or Aster database table in which you want to delete rows.
  2. Right-click the table object and select one of these options: .
    For Select
    Vantage Database Teradata > Generate SQL > DELETE Statement
    Aster Database Aster > Generate SQL > DELETE Statement
  3. In the SQL Editor, review the generated DELETE statement and optionally add conditions to the WHERE clause to delete rows.
  4. Click "" to execute the DELETE statement and delete the row in the table.