16.20 - Creating Custom SQL Sets - 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
  1. Select Help > Query Builder.
  2. Click .
  3. In the dialog that appears, enter a name for this new SQL Set and click OK.
    The new name appears in the drop-down box.
  4. Click .
  5. In the dialog that appears, enter a name for the new example, query, or snippit, and click OK.
  6. In the right pane, enter the SQL for the example, query, or snippit.
  7. Click to save the SQL set.
    All SQL sets created and saved appear on the drop-down menu. The following table explains each icon in Query Builder.
    Icon or Menu Description
    Click the New SQL Set (Ctrl+N) icon to create a new list of statements. Enter the set name in the dialog that appears. This name then appears in the drop-down list.
    Click the Save SQL Set (Ctrl+S) icon to save changes to the current SQL set.
    Delete SQL Set (Ctrl+D) Deletes the current SQL set. Confirm your deletion request when prompted.

    Click the Add SQL (Insert) icon to add a new item to the list in the current SQL Set.

    This option is also available by right-clicking a statement.

    Click the Delete SQL icon to delete the current list item from the current SQL Set.

    This option is also available by right-clicking a statement.

    Insert into query (Ctrl+I) Inserts the statement into the active Query window.
    Replace query (Ctrl+R) Inserts the selected statement in the active Query window by replacing the existing statement.
    Copy to clipboard (Ctrl+C) Copies the selected statement to the clipboard.
    Show Syntax Displays the full syntax of the selected statement. This menu only appears when you are connected to a Teradata Database and have selected the SQL Statements item from the drop-down list.
    Rename SQL (Ctrl+H) Changes the name of the selected statement.