16.00 - Data Source Explorer Load Preferences - Teradata Studio

Teradata Studio User Guide

prodname
Teradata Studio
vrm_release
16.00
created_date
March 2017
category
User Guide
featnum
B035-2041-126K
The Data Source Explorer Load Preferences enable you to configure your preference settings for loading database and user objects and to determine what folders are shown in the Data Source Explorer hierarchical tree display. You can set preferences to:
  • Load databases and users:
    • All databases and all users
    • Load only databases and certain users
    • Load all databases and users with PermSpace configured
  • Configure the hierarchical display to show:
    • All databases and all users
    • Only certain folders you specify
  • Whether to load object details for:
    • Table space and journals
    • Column data types in views.
  • Whether filters created for folders in the Data Source Explorer should be case-insensitive. The default is for filters to be case-sensitive. Check the option if you want filters to be case-insensitive.

What to Load

Use radio buttons in this section to set preferences for which objects you want loaded to the Data Source Explorer view.

Option Description
All Databases and Users Loads all database and user objects for the connected database. Option selected by default.
Only Databases (but include DBC user) Loads all databases and the DBC user, but no other user objects.
Only Databases (but include DBC user and myself) Loads all databases, the DBC user, and the current user.
Databases and Users with PermSpace Loads all databases and users with PermSpace configured.
User Choice (includes DBC) Enables user to select only folders they want displayed in the Data Source Explorer tree hierarchy. If all boxes are checked in What to Display (default), this option is not available.

What to Display

Use the check boxes in this section to set preferences for which folders you want shown in the Data Source Explorer hierarchical tree display.

Option Description
Show Databases and Users in Hierarchical Display Displays database and user objects in an expandable hierarchical view. Option selected by default.
Include Database Indexes Folder Displays index objects in the Indexes folder. Option selected by default.
Include Macros Folder Displays macro objects in the Macros folder. Option selected by default.
Include Stored Procedures Folder Displays stored procedures objects in the Stored Procedures folder.
Include Tables Folder Displays table objects in the Tables folder. Option selected by default.
Include User-Defined Functions Folder Displays user-defined function (UDF) objects in the User-Defined Functions folder. Option selected by default.
Include User-Defined Types Folder Displays user-defined type (UDT) objects in the User-Defined Types folder. Option selected by default.
Include Views Folder Displays view objects in the Views folder. Option selected by default.

Load Object Details

Select the object details to include when loading objects in the Data Source Explorer. All object details are selected by default.

Option Description
Load Tables space and journal details If selected, when table information loads in Data Source Explorer, the space and journaling data is included. Option selected by default.
Load View Columns Data Types If selected, when view information loads in Data Source Explorer, column data types are included. Option selected by default.