Database Tree Default Preferences and Descriptions - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

Product
SQL Assistant
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2430
lifecycle
previous
Product Category
Teradata Tools and Utilities

Database Tree Default Preferences and Descriptions

 

Table 44: Database Tree Default Preferences and Descriptions  

Preferences

Default

Description

LoadDBTreeAll

False

Load a user defined list of databases into the database tree.

DBTreeSource

DBC.DatabasesX

When adding all databases, this is the table/view that is read to obtain the list

ExcludeUsers

True

When adding all databases, only the databases and not the users are loaded

SaveTreeData

False

Do not save the Database Explorer Tree data to a file and reload it next time

UseFastSchema

False

Use the standard catalog functions to return both the column name and the data type for each column in a view.

UseCatalog

False

Use the ODBC 'schema' field (not 'catalog') for ‘unknown’ vendor databases

QualifyNames

False

Do not qualify object names with their parent names when dragging objects from the Database Tree

QuoteNames

False

Do not enclose object names in double quotes when dragging objects from the Database Tree

ShowTriggers

False

Trigger and Join Index nodes are not shown in the Database Explorer Tree