Query Development | SQL Editor Templates | Teradata Studio/Studio Express - SQL Editor Templates - Teradata Studio

Teradata® Studio™ Express User Guide - 17.20

Teradata Studio
Release Number
September 2022
English (United States)
Last Update
Product Category
Teradata Tools and Utilities
SQL templates for creating SQL statements in the SQL Editor are provided in three ways:
  • Generate SQL options — SELECT, INSERT, UPDATE, and DELETE statement templates for tables. These Generate SQL options are available from the Query Development perspective when you right-click a table object in Data Source Explorer.
  • Content Assist templates — In-context insertion of SQL statements in SQL Editor. To invoke the SQL Templates, place your cursor at the point in the SQL text where you want assistance and enter CTRL+SPACE.
  • Templates View for Aster analytical functions — Aster-only view that displays a list of function templates you can drag and drop into the SQL Editor.

Use templates provided through the Content Assist mechanism to create Data Manipulation Language (DML) type SQL statements, such as DELETE, INSERT, SELECT, and UPDATE. Template variables support tabbing from one variable to another. Template variables are linked allowing you to change one occurrence of a variable, for example, tablename1, and automatically change all occurrences of that same variable in the template. The Content Assist selection list includes all available SQL templates for creating SQL at the cursor insertion point in the text.