Explorer Options

From RapidSQL
Jump to: navigation, search

Go Up to Configuring Feature Options

The Explorer options are available on the following Options Editor tabs:

Explorer Options - Main Tab

The Options Editor’s Explorer tab controls the appearance and behavior of the Datasource Navigator.

Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.
Note: For related information, see Using the Datasource Navigator.

Use the following table as a guide to modifying settings on this tab

Setting Description

Refresh after Object Commands

Refreshes the Explorer automatically after an object has been modified or created.

Retain View Setting on Close

Select to retain the current state of the Datasource Explorer so that it opens the same way on the next startup.

Column filters use regular expressions by default

Lets you use regular expressions when defining criteria for display of database objects in the right-hand pane of the Explorer.

Display Explorer on startup

Activates the Datasource Explorer on startup. For more information, see Using the Datasource Navigator.

Landing Page View

Enables landing page views on a DBMS-by-DBMS basis. Landing pages display informative metadata that gives you a quick overview of your server/database.


Explorer Options - Organization Tab

The Options Editor’s Explorer > Organization tab controls the appearance and behavior of the Datasource Navigator.

Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.
Note: For related information, see Using the Datasource Navigator.

Use the following table as a guide to modifying settings on this tab

Setting Description

Explorer organization

Lets you select a default grouping option of Organize by Object Owner (groups objects, by object type, for each user) or Organize by Object Type (groups objects by object type for all users in the same list). Grouping by object owner is most efficient if you are working with databases containing a high number of objects. You can change the organization manually during a session. For details, see Basic Viewing Options in the Navigator.

Show System Objects and Show Only My Objects (available if you are organizing the Datasource Explorer by object type)

Lets you select a default Datasource Explorer tree display options for system objects and objects that you own. Available options in the two groups are: Never - the relevant objects are not displayed by default. Always - the relevant objects are always displayed by default. Use datasource filter - The relevant default datasource filter is enabled. For more information, see Filtering in the Navigator. You can change the Show System Objects and Show Only My Objects settings manually during a session. For details, see Basic Viewing Options in the Navigator.


Explorer Options - Limits Tab

The Options Editor’s Explorer > Limits tab controls the appearance and behavior of the Datasource Navigator.

Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.
Note: For related information, see Using the Datasource Navigator.

While the DBMS is queried as necessary when you navigate the node hierarchy, it also caches nodes for the purpose of quickly repopulating if you move away from and then back to a node. For example if you open a Tables node and then an Indexes node and then again select the Tables node, the cached Tables sub-nodes are displayed.

The following setings are available

Setting Description

Cache Expiration Time

The duration a node is cached. Selecting a node after this expiration interval results in a fresh population.

Maximum number of children to display per tree node

Lets you place an upper limit of the number of nodes to display per node.


Explorer Options - Browsers Tab

The Options Editor’s Explorer > Browsers tab controls the appearance and behavior of the Database Navigator

Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.

Use the following table as a guide to modifying settings on this tab

Interface Element Setting Description

Default Owner

All Owners

Indicates that the Browser Window should default to displaying database objects in the browsers for all owners in the database.

Current User

Indicates that the Browser Window should default to displaying database objects owned exclusively by the current user.

Specific Owner

Indicates that the Browser Window should default to displaying only the database objects owned by a specific owner. If you select this option, you must provide an owner name in the box.

Mail File Type

Specifies what file type you want the browser file saved as when sent as e-mail to another user on a MAPI compliant mail system. The valid types are the proprietary Rapid SQL Results type, Tab delimited, Comma separated, and HTML, which formats the results in a simple HTML table.

Browser colors

Lets you specify foreground and background colors for object types displayed in the Browser

Personal tools