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.
- Click Window in the top menu and select Preferences.
- Expand Teradata Datatools Preferences.
- Select Data Source Explorer Load Preferences.
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.
Under What to display, select the folders to
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.
- [Optional] To select all options to display, click Select All.
- [Optional] To clear your selections, click Clear All.
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.
- [Optional] To reset and restore default selections, click Restore Defaults.
- To apply your changes, click Apply.
- 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.