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

Teradata Studio Express User Guide

prodname
Teradata Studio
vrm_release
15.12
created_date
August 2016
category
User Guide
featnum
B035-2042-086K
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.