Displaying the Shortcut Menu - SQL Assistant

Command

Description

Execute

Submits the query currently in the Query Window. Each statement in the query is submitted separately to the database.

Query Builder

Helps you create statements in the Query Window.

Add to Favorites

Saves the current query to a list of favorites which can be reused from Query Builder.

Cut

Cuts the selected text from the Query Window and places it to the Clipboard.

Copy

Copies the selected text from the currently active window to the Clipboard.

Paste

Pastes the contents of the Clipboard into the query at the current insertion point.

Find

Displays the Find String in Query dialog box, allowing you to search for a particular string in the currently active window. Find highlights the first occurrence of the string.

Repeated use of the Find Next button highlights successive occurrences of the search string.

Find Next

Finds the next occurrence of the string that was specified in the previous Find command. If you have not yet issued a Find command, it acts as a Find command

Replace

Finds and replaces any, or all, occurrences of a particular string in the Query Window. This command is useful for quickly replacing a string that occurs multiple times in your query. For example, use this command to change the name of a database referenced multiple times within a macro or script.

Format Query

Formats a query based on a search for specific keywords.

Set Font

Displays a Font dialog box allowing you to change the font used in the current window.

The Font Name and Font Size attribute are saved for future use. Separate values are stored for each type of window.

Select All

Selects all the text in the current window. All text is highlighted and future actions apply to the entire window as a whole.

The primary use of this function allows you to copy the query to the Clipboard.

Insert date

Inserts today’s date into the query at the current insertion point. If part of the query is selected, this function replaces the selected text with today’s date.

The format of the date is always 'yyyy-mm-dd' enclosed in quotes, or in '#' signs for Microsoft Access.

Audible Notification

Causes the system to beep when the query is complete and all data has been returned to your PC. The beep also occurs if the query times out, the number of rows exceeds the output limit, or the query is canceled.

Minimize on Execution

When selected, automatically minimizes the Teradata SQL Assistant window when a query is being processed.

Prompt for Notes

An input dialog box displays whenever you submit a query to enter a note that is stored in the history table along with the query.