Displaying the Shortcut Menu - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

SQL Assistant
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

Displaying the Shortcut Menu

There are several ways to display additional menu options. Table 7 describes all of the commands.

  • Do one of the following:
  • Right-click an object and select a menu item.
  • Press Shift+F10.
  • Press Context Menu on the keyboard.

    Table 7: Explorer Tree Shortcut Menu Commands 



    Quick Paste

    Pastes the current object name into the Query Window. The name is inserted at the current insertion point. To insert the name at a different point, drag and drop it within the query text.

    Show Definition

    Displays the text used to create an object in the Database Explorer Tree. The DDL (data definition language) of a table, view, macro or stored procedure appears in the Answerset Window. Right-click the object to show the definition, then select this command.


    Expands or collapses the display for the selected object. If the selected object has not been previously opened, the child data (for example, the list of tables) is fetched from the database. If the selected object has no children, it is removed from the tree.

    Add Database

    Adds additional databases to the Database Explorer Tree.

    Refresh Database

    Refreshes the objects shown below a database in the tree. Right-click the database to refresh, then select this command.

    Note: Only object types previously expanded are refreshed.

    Remove Database

    Removes a database from the Database Explorer Tree.

    Generate SQL – The commands on this menu generate and insert SQL into the Query window.

    An example of the inserted SQL is shown for each command below. In these examples

  • <name> is the Table or View name
  • <a, b, c, ...> is the list of columns in that table or view
  • Select

    Select <a, b, c, ...> from <name>.

    Insert (Values)

    Insert into <name> ( <a, b, c, ...>)

    Values (<a [datatype], b [datatype], c [datatype], ...>)

    Insert (Import)

    Insert into <name> ( <a, b, c, ...>)

    Values (?, ?, ?, ...)


    Create Table <name>


    <a [datatype],

    b [datatype],

    c [datatype]>


    Primary Index (x)