16.00 - Inserting Table Rows using an INSERT Template - Teradata Studio

Teradata Studio User Guide

Teradata Studio
March 2017
User Guide
You can generate an INSERT statement template in the SQL Editor that inserts rows in a Teradata or Aster database table. The INSERT (Values) Statement menu option enables you to modify the generated statement and provide all query values. If you want to create a parameterized query, select the INSERT (Parameterized) Statement menu option.
  1. Click Query Development to open the Query Development perspective.
  2. Open the Data Source Explorer and navigate to the table in which you want to insert rows.
  3. Right-click the table object and select one of these options:.
    For Select
    Teradata Database Teradata > Generate SQL > INSERT (Values) Statement
    Aster Database Aster > Generate SQL > INSERT (Values) Statement
  4. In the SQL Editor, modify the generated INSERT statement to specify the values for the columns based on data types.
  5. Click to execute the INSERT statement to insert the row into the table.