Creating Custom SQL Sets
Query Builder lets you create custom SQL Sets.
To create a custom SQL Sets
1 Open Query Builder, Help> Query Builder.
2 Click the New SQL Set button . In the dialog box that appears, enter a name for this new SQL Set and click OK. The new name appears in the drop down box.
3 Click the Add SQL button . In the dialog box, enter a name for the new Example, Query, or Snippit, and click OK. Then in the right pane, enter the SQL for the Example, Query, or Snippit.
4 Click the Save button 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 box 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 dropdown list. |
Rename SQL (Ctrl+H) |
Changes the name of the selected statement. |