Set Data Source Explorer Load Preferences | Teradata Studio - Setting Data Source Explorer Load Preferences - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
17.00
Published
January 2021
Language
English (United States)
Last Update
2021-01-11
dita:mapPath
lex1576517377362.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
Use the Data Source Explorer Load Preferences to configure your preference settings for loading database and user objects and determine which folders are shown in the Data Source Explorer hierarchical tree display.
  1. Select Window > Preferences.
  2. Expand Teradata Datatools and select Data Source Explorer Load.
  3. Under 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.
    User Choice (includes DBC) Read-only by default; becomes enabled if Show Databases and Users in Hierarchical Display is not checked under What to display.
  4. 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.
  5. [Optional] To select all options to display, click Select All.
  6. [Optional] To clear your selections, click Clear All.
  7. Under 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.
  8. [Optional] To reset and restore default selections, click Restore Defaults.
  9. To apply your changes, click Apply.
  10. Click OK to apply your changes and close the Preferences dialog.
    The database and user folders in the Data Source Explorer refresh to reflect the settings you selected.