Setting Database Tree Preferences - SQL Assistant

Options

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 amount of 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.

Note: 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.