Setting Data Source Explorer Load Preferences - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
sbq1486739977986.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities

Use Data Source Explorer Load Preferences to configure your preference settings for loading database and user objects in Data Source Explorer (DSE). You can also set preferences to determine what folders are shown in the hierarchical display.

  1. Click Window in the top menu and select Preferences.
  2. Expand Teradata Datatools Preferences.
  3. Select Data Source Explorer Load Preferences.
  4. Under Load options for the Data Source Explorer What to load, select the objects to load:
    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.
  5. Under What to display, select the folders to show:
    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.
  6. [Optional] To select all options to display, click Select All.
  7. [Optional] To clear your selections, click Clear All.
  8. In Load Object Details, select one or both of the following options:
    Option Description
    Load Tables space and journal details If selected, when table information loads in Data Source Explorer, the load operation includes the space and journaling data. This option is selected by default.
    Load View Columns Data Types If selected, when view information loads in Data Source Explorer, the load operation includes the column data types. This option is selected by default.
  9. [Optional] To reset and restore default selections, click Restore Defaults.
  10. To apply your changes, click Apply.
  11. Click OK to apply your changes and close the preference dialog. The database and user folders in the Data Source Explorer refresh to reflect the settings you selected.