You can generate a DELETE statement template in the SQL Editor to delete rows in an Aster Database table.
- Click Query Development to open the Query Development perspective.
- Open the Data Source Explorer and navigate to the Teradata or Aster database table in which you want to delete rows.
-
Right-click the table object and select one of these options: .
For Select Teradata Database Aster Database - In the SQL Editor, review the generated DELETE statement and optionally add conditions to the WHERE clause to delete rows.
- Click to execute the DELETE statement and delete the row in the table.