16.10 - Deleting Table Rows using a DELETE Template - Teradata Studio

Teradata Studio Express User Guide

prodname
Teradata Studio
vrm_release
16.10
created_date
June 2017
category
User Guide
featnum
B035-2042-067K
You can generate a DELETE statement template in the SQL Editor to delete rows in an Aster Database table.
  1. Click Query Development to open the Query Development perspective.
  2. Open the Data Source Explorer and navigate to the Teradata or Aster 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 > DELETE Statement
    Aster Database Aster > Generate SQL > DELETE Statement
  4. In the SQL Editor, review the generated DELETE statement and optionally add conditions to the WHERE clause to delete rows.
  5. Click to execute the DELETE statement and delete the row in the table.