You can generate an UPDATE statement template in the SQL Editor to update table rows.
- Click Query Development to open the Query Development perspective.
- Open the Data Source Explorer and navigate to the 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 UPDATE statement and optionally add conditions to the WHERE clause to update rows.
- Click to execute the UPDATE statement and update the row in the table.