16.20 - Displaying Commands for the Database Explorer Window - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty
  1. Do one of the following
    • Right-click an object and select a menu item.
    • Press Shift+F10.
    • Press Context Menu on the keyboard.
    Command Description
    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.
    Expand/Collapse 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.
    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

    Create Table <name>

    (

    <a [datatype],

    b [datatype],

    c [datatype]>

    )

    Primary Index (x)