| Toolbar Button | Name | Menu | Description |
|---|---|---|---|
|
Connect | Main toolbar | Selects a data source and connect. See Connecting to and Disconnecting from a Data Source for more information about connecting to data sources. |
|
Disconnect | Main toolbar | Click to disconnect from the current data source. |
|
Data Provider | Main toolbar | Use the drop down box to select the data provider you want to use. The providers include ODBC and .NET for Teradata or Oracle. See Defining a Data Source for more information. |
|
New Query | File | Opens a new tab in the Query window. This selection is only available if the option Allow multiple queries per connection is selected. |
|
Open Query | File | Opens a previously saved query or reads a file into the Query window. |
|
Close All Queries tabs | File | Closes all queries. This selection is only available if the option Allow multiple queries per connection is selected. |
|
Save | File | Saves the contents in the active window. |
|
Save As | File | Saves the contents in the active window after prompting for a new file name. |
|
Copy to Notepad | File | Runs the Microsoft Windows Notepad application and transfers the contents of the active window for additional editing. |
|
Print Preview | File | Previews the Answerset and History window before printing. See Using Print Preview for more information. |
|
File | Prints the contents of the active window. | |
|
Export Results | File | Exports future query results to a Microsoft Access or delimited text file. |
|
Import Data | File | Switches on import mode where parameter data is read from a text file. |
|
Undo | Edit | Undoes the last change made in the Query window. |
|
Redo | Edit | Redoes the last change made in the Query window. |
|
Cut | Edit | Cuts the selected text to the Clipboard. |
|
Copy | Edit | Copies the selected text to the Clipboard. |
|
Paste | Edit | Pastes the contents of the Clipboard into the Query window. |
|
Clear Query | Edit | Clears the current query. |
|
Format Query | Edit | Formats the query by adding line breaks and indentation at appropriate points. |
|
Right-to-left editor | Edit | Opens an Editor window for writing queries in languages that use a right-to-left format. For more information, see Using the Right-to-Left Editor for Queries. |
|
Find | Edit | Searches the active window for the desired text string. |
|
Find Next | Edit | Searches for the next occurrence of the string that was specified in the previous Find command in the active window. If you have not yet issued a Find command, it acts as a Find command. |
|
Find Previous | Query toolbar | Searches for the previous occurrence of the string that was specified in the previous Find command in the active window. If you have not yet issued a Find command, it acts as a Find command. |
|
Replace | Edit | Finds and replaces any or all occurrences of a particular string in the Query window. |
|
Add Totals | Edit | Displays totals at the bottom of numeric columns. The totals remain after the Answerset has been sorted. Totals do not appear in future Answerset windows unless Add Totals is activated again. |
|
Sort | Edit | Sorts the data in the active window. |
|
Explorer Tree | View | Displays or hides the Database Explorer Tree. |
|
Go To Favorites | View | Moves focus to the Favorites pane, first displaying it if it is not currently visible. |
|
Set Font | View | Changes the font type, style, and size in the active window. |
|
Show History | View | Displays or hides the History window. |
|
Previous SQL | View | Copies the SQL from the previous history record to the Query window. |
|
Next SQL | View | Copies the SQL from the next history record to the Query window. |
|
Toggle Outline | View | Collapses a logical section of the query, or expands a collapsed section. |
|
Execute | Tools | Executes the SQL statements in the Query window. Each statement is submitted separately. |
|
Abort | Tools | Aborts an executing, or in-flight, query. |
|
Execute Parallel | Tools | Executes the SQL statements in the Query window. The entire query is submitted as a single request. |
|
Reconnect | Tools | Reconnect the current Query window to a connection that was dropped for some reason, such as the client PC going into Hibernating mode. |
|
Explain | Tools | Displays an Explain plan for the query. |
|
Visual Explain | Tools |
Opens Teradata Visual Explain so you can display a visual EXPLAIN of a single-statement query currently in the Query window. You can move this command to a menu or toolbar only if:
|
|
Teradata Query Scheduler | Tools |
Opens Teradata Query Scheduler so you can schedule your query for later execution. You can move this command to a menu or toolbar only if:
|
|
List Tables | Tools | Opens the Table List dialog where you can enter the name of the database whose tables or views you want to list. The resulting list of tables or view displays in an Answerset window. |
|
List Columns | Tools | Opens the Column List dialog where you can list the columns in a particular table or view in the selected database. The resulting list of columns displays in an Answerset window. |
|
Edit History | Tools | Opens the Edit History dialog. For more information, see Editing History Records. |
|
Cascade | Window | Cascades all the child windows within the Teradata SQL Assistant parent window. |
|
Tile Horizontal | Window | Tiles the child windows horizontally to fit within the Teradata SQL Assistant parent window. |
|
Tile Vertical | Window | Tiles the child windows vertically to fit within the Teradata SQL Assistant parent window. |
|
New Horizontal Tab Group | Window | Moves the current window to a new tab group, created below the current tab group. |
|
|
New Vertical Tab Group | Window | Moves the current window to a new tab group, created next to the current tab group. |
|
Help Topics | Help | Displays the contents tab for the Help file. |
|
Audible Notification | Query shortcut | Prompts your system to beep when the query has completed 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. It is also located on the Query shortcut menu. |
|
Minimize on Execution | Query shortcut | Automatically minimizes the Teradata SQL Assistant window when a query is being processed. |
|
Prompt for Notes | Query shortcut | Prompts you for a note before running any query. This option causes the system to display an input dialog box whenever you submit a query. |
|
Add to Favorites | Query shortcut | Adds the current query or selected text to a Favorites collection. Once the query is added as a favorite, it can be selected for reuse from the Query Builder window. See Adding a Query to Favorites. |
|
Query Builder | Query shortcut | Opens the Query Builder window. |
|
Insert Date | Query shortcut | Inserts the current date in the query where ever the cursor is placed. |
|
Bookmark | Query toolbar | Adds or removes a bookmark at the current line. |
|
Next bookmark | Query toolbar | Moves to the next bookmark. |
|
Previous bookmark | Query toolbar | Moves to the previous bookmark. |
|
Remove All Bookmarks | Query toolbar | Removes all bookmarks. |
|
Show White Space | Query toolbar | Displays symbols for tabs and spaces. |
|
Indent | Query toolbar | Indents text to the right. |
|
Unindent | Query toolbar | Indents text to the left. |
|
Comment Text | Query toolbar | Turns the selected text (or the current line, if no text is selected) into a comment, or turns the current comment into text. |
|
Select Block | Query toolbar | Selects a logical block of text when the cursor is positioned at either the start or end delimiter (for comments, parens, Case/End, and so on). |
|
Delete blank lines | Query toolbar | Deletes blank lines from a currently selected part of a query. |
|
Convert tabs to spaces | Query toolbar | Converts tabs to spaces in a query. |
|
Uppercase | Query toolbar | Converts the selected text to uppercase. |
|
Lowercase | Query toolbar | Converts the selected text to lowercase. |
|
Set Repeat Count | Query toolbar | Sets the number of times the next keyboard command or macro is executed. |
|
Record Macro | Query toolbar | Records a keystroke macro for later playback. |
|
Stop Recording | Query toolbar | Stop recording the current keystroke macro. |
|
Play Macro | Query toolbar | Opens the Keyboard Macros dialog to allow selection of the macro to be played. |
|
Replay Macro | Query toolbar | Replays the most recently played macro. If no macro has been played, then it displays the Keyboard Macros dialog to allow selection of the macro to be played. |
|
Column Headers | Answerset shortcut | Displays or hides column headers. |
|
Toggle SQL/Answer | Answerset shortcut | Switches between displaying the SQL statement that generated the Answerset or the Answerset data. |
|
Move Columns | Answerset shortcut |
Places you into “Move Columns” mode, allowing you to rearrange the columns by clicking on a column header and dragging it to the desired position. To switch off Move Columns mode, click on this item a second time. The default for Move Columns mode is off. While in this mode, columns can no longer be selected by clicking on their column headers.
|
|
Chart | Answerset shortcut | Opens the Define Chart dialog to allow you to specify the columns and rows to be charted, along with the chart type and other criteria. |
|
Freeze Columns | Answerset shortcut |
Selecting this item “freezes” the left most columns, preventing them from being scrolled off the screen when you scroll a wide Answerset to the right. All columns up to the current column or cell are frozen. Click Freeze Columns a second time to unfreeze the columns. The default for Freeze Columns is Off. |
|
Decimal Places | Answerset shortcut | Displays a menu to select the number of decimal places to be displayed in the current column. |
|
Group Columns | Answerset shortcut | Allows grouping. |
|
Grid Lines | Answerset shortcut | Displays or hides gridlines in the current Answerset window. |
|
Merge Cells | Answer shortcut | Merges cells that contain the same data in consecutive rows of the Answerset. |
|
Row Headers | Answer shortcut | Displays or hides row headers. |
|
Wrap Text | Answer shortcut | Wraps the text onto multiple lines if it does not fit entirely within the column on 1 line. |
|
Allow Close | Answer shortcut | Allows automatic closing of the selected Answerset window. |
|
Do Not Close | Answer shortcut | Prevents automatic closing of the selected Answerset window. |
|
Copy as HTML | Answer shortcut | Copies the selected text from the currently active window to the Clipboard as HTML |
|
Format Cells | Answer shortcut | Set the formatting options for the selected cells. |
|
Filter | History shortcut | Opens the History filter dialog. See Filtering the History Rows for more information. |
|
Clear Filter | History shortcut | Clears the History filter. |