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. |