- Select .
- Click .
-
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.
- Click .
- In the dialog that appears, enter a name for the new example, query, or snippit, and click OK.
- In the right pane, enter the SQL for the example, query, or snippit.
-
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.