16.20 - Setting Database Tree Preferences - 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. Select Tools > Options.
  2. In the Options dialog, click the DB Tree tab.
  3. Complete the following fields.
    Option Description
    Load my user defined list of databases This is the default option. The user DBC, current logon user, default database, and any databases or users previously defined for this data source are loaded.
    Load the databases and users from a Table or View This option is only available when connecting to a Teradata data source. This option reads the database names from the table or view specified in the next field.
    Load from this source Enter the name of the table or view to load database names from. By default, this view name is DBC.DatabasesVX. If an unqualified name is entered, the assumption is that the name is in database DBC. This table/view must contain the columns DatabaseName and DBKind. DBKind should be set to D to indicate a database. Any other value is assumed to be a User.
    Exclude all users except for DBC and myself The default is selected. When selected, all databases are loaded, and users are excluded. The only users that are loaded are DBC and the current logon user.
    Save Database Tree information to disk and reload it at startup

    The default is cleared. When selected, all the information currently in the database tree is saved to disk before Teradata SQL Assistant is shut down. The database tree information is reloaded when opened again.

    The column information automatically loads for all tables and views in the database when you expand the Tables or Views folders in the database tree.

    Load only column names for Views — Much faster (Teradata only)

    The default is cleared. This option is only available when Save Database Tree information to disk and reload it at startup is selected.

    Select this option to load only the column names for Views. Using this option speeds up the time it takes to load database information for a database that contains many views.

    Qualify Names when dragged or pasted from the Database Tree The default is cleared. When selected, Table, Column, and other names are qualified with their parent name when dragged from the Explorer Tree, or when the Quick Paste menu is used.
    Enclose names in quotes when dragged or pasted from the Database Tree The default is cleared. When selected, names are enclosed in double quotes when dragged from the Explorer Tree, or when the Generate SQL or Quick Paste menus are used.
    Display Triggers, Join Indexes and Materialized Views

    The default is cleared. When selected an Indexes node is added below each database. This node can be expanded to display the Join and Hash Indexes defined in the database. In addition, a Triggers node is added below each Table.

    The term Indexes are only used for Teradata data sources. Other terms such as Materialized Views are used for other vendors, as appropriate.
    Use alternate schema when loading the Explorer Tree for Unknown vendors Select this item if you are connected to an unknown (unsupported) database and no objects appear in the Explorer Tree.