Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal
< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7
You are here: Configure Options > Explorer > General

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. Click | Options (ALT+T+O) and select 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: Invoke default action

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

    Notes:

    • To view the schema/database owner beside the object name, select the Show schema in separate column checkbox in Tools | Options | Database | SQL Server. See SQL Server Options for more information.
    • 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 and owner 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. See Query Builder Options for more information.

    Default: Cleared

Tips:

 

Related Topics

Database Explorer

Object Explorer