16.20 - Inserting SQL for the Selected Table or View into the Query Window - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty
Use the following procedure to insert a statement template for the selected table or view into the Query window rather than dragging individual column names to build a statement that references many columns of a table.
  • If the Ctrl key is pressed when the menu is clicked, the SQL is inserted into the current Query tab at the cursor position.
  • If the Ctrl key is not pressed, the SQL displays in a new Query tab if the current query has been changed since it was last saved or executed, or the SQL replaces the current query if it has not been changed since it was last saved or executed.
  1. Right-click the object and select Generate SQL.
  2. Click one of the sub menus to insert the SQL.
    Menu Item Inserted SQL Example
    Select Select col1, col2, col3 From MyTable
    Insert (Values)
    • Insert Into MyTable (col1, col2, col3)
    • Values (col1 [Integer], col2 [Char(5)], col3 [BLOB])
    Insert (Import)
    • Insert Into MyTable (col1, col2, col3)
    • Values (?, ?, ?B)
    Create Inserts the DDL of the object