Insert Table Rows using an INSERT Template | Teradata Studio/Studio Express - Inserting Table Rows using an INSERT Template - Teradata Studio

Teradata® Studio™ User Guide - 17.20

Product
Teradata Studio
Release Number
17.20
Published
September 2022
Language
English (United States)
Last Update
2022-09-23
dita:mapPath
gvw1648839236371.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
Product Category
Teradata Tools and Utilities
Use the INSERT (Values) Statement menu option to modify the generated statement and provide all query values. Or, select the INSERT (Parameterized) Statement menu option to create a parameterized query.
  1. In the Data Source Explorer, navigate to the table in which you want to insert rows.
  2. Right-click the table object and select one of these options:.
    For Select
    Vantage Teradata > Generate SQL > INSERT (Values) Statement
    Aster Database Aster > Generate SQL > INSERT (Values) Statement
  3. Modify the generated INSERT statement to specify the values for the columns based on data types.
  4. Click "" to execute the INSERT statement to insert the row into the table.