Chat now with support
Chat with Support

Please note, you may experience access issues between 6am - 7am Eastern time on Saturday, May 28 2022 due to planned maintenance

Toad Data Point 5.3 - Release Notes

General Explorer Options

This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To set general explorer options

  1. Select Tools | Options |Explorer | General.

  2. Review the following for additional information:

    Prompt to filter list after

    Enter the number of objects to retrieve in the Object Explorer before you are prompted to set a filter. This is useful when you have a large database and do not want to wait for all objects to be retrieved.

    Default: 2500

    Subfolder location in list

    Select where you want to display any subfolders and system objects in the object list.

    Default: Bottom

    Double-click behavior

    Select whether to open a Viewer window that contains object details such as properties, columns, data, and a script or to open an Alter window for the object when double-clicking the object in the Object Explorer.

    Default: Open details

    Default Filter

    Specify a default option to use when creating a new filter in the Object Explorer.

    Default: Last Selected

    Use Object Details to display current details

    Select this checkbox to display details for a selected object in the Object Details window. This is useful if you are using the Editor and want to quickly locate information in table columns.

    Default: Cleared

    Sort list alphabetically when in drop-down mode

    Select this checkbox to sort the object types and each object alphabetically when you select drop-down mode to display objects.

    Default: Selected

    Allow editing of the schema or database list

    Select this checkbox to edit the Choose Database drop-down field to help you quickly find an object from a long list.

    Default: Selected

    Display followed links in object details

    Select this checkbox to display object links selected in the Object Details pane of the Database Explorer. This is useful for navigating to objects that reference the selected object.

    Default: Cleared

    Automatically format generated SQL Select this checkbox to apply current formatting options to SQL when you right-click an object and select Generate SQL | option or Send To | Editor as Script.
    Separate schema or database by type (Only for non treeview)

    Select this checkbox to remember the last schema or database selected for this object type. For example, if you select a table from the HR database, then select a view from the Inventory database, when you select tables again, Toad defaults back to the HR database.

    (DB2 only) Select this checkbox to remember the last schema or schema filter selected for each object type as you navigate the current DB2 database or subsystem. Additionally, Toad reinstates these schema filters each time you connect to that same database or subsystem.

    Note: This option does not apply to object lists formatted in the Tree or Flat Tree view.

    Default: Cleared

    Use fully qualified object names when dragging objects

    Select this checkbox to add the database/schema name when dragging an object into the Editor.

    If you want to fully qualify object or column names for the Query Builder, set Query Builder options. Query Builder Options

    Default: Cleared


  • To navigate to the directory where option settings are stored, click the Application Data Directory link in the About dialog (Help | About).

  • To search for a partial or complete option name or value, use the Search field at the bottom of each Options page. About Options


Related Topics

Database Explorer

Object Explorer

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating