Chat now with support
Chat with Support

Toad for Oracle 12.12 - Getting Started Guide

Table of Contents Welcome to Toad Toad Resources Required Privileges Create and Manage Database Connections Editor Basics Schema Browser Basics Data Grid Basics Work with Data Work with Database Objects Work with Code
Write Statements and Scripts Work with the Query Builder Execute Statements and Scripts Save Statements (SQL Recall) Work with PL/SQL Objects Debug Analyze Code Optimize SQL
Customize your Toad Environment Use Other Quest Software Products with Toad

Customize the Schema Browser

Toad provides many ways for you to customize the interface to suit your work style and improve your productivity. Most areas of the interface are customizable, from the toolbars and menus, to the grids and workspace itself. You can also set custom defaults for actions, commands, and other tasks that Toad performs for you.


Select the Left-Hand Side Display Style

You can customize how the Schema Browser displays to better suit the way you work. The most common customization is to change how object types display in the left-hand side. Once you select a basic display style, you can rename, hide, or rearrange the object types on the left-hand side and detail tabs on the right-hand side. Customize Schema Browser Tabs


  • To hide the right-hand side of the Schema Browser, press F12. You can press F12 again to display it again.
  • To hide or display images and tips in the left-hand side, click in the Schema Browser toolbar and select the appropriate option.
  • In drop-down mode, you can hide leading characters of object names in the left-hand side. Right click a column and select Hide leading characters of name. The display resets when you change the schema or connection.

To select the left-hand side display style

  1. Click in the Schema Browser toolbar.
  2. Select one of the following options:
    Option Description


    Displays object types in an alphabetical drop-down field.

    Tabbed (single row of tabs)

    Displays object types as a single line of tabs. You must scroll through the tabs to view all object types.

    Tabbed (multi line tabbed)

    Displays multiple rows of tabs instead of the scroll bar.

    Tree view

    Displays object types in a tree view.

    Note: You may need to close any open instances of the Schema Browser for the new browser style to display.


Customize Tabs

The Schema Browser displays object types on the left-hand side and detail tabs on the right-hand side. You can rename, rearrange, and hide the object types that display in the left-hand side or the tabs on the right-hand side.

To customize tabs and object types

  1. Click on the Schema Browser toolbar.
  2. Select Configure LHS Object Types to customize the left-hand side, or select Configure RHS Tabs to customize the right-hand side.
  3. Customize the display settings.
    If you want to... Complete the following:
    Rename an object type or tab Enter a new name in the Caption field.
    Hide an object type or tab Clear the Visible field.
    Rearrange tabs

    Select a tab and click the up or down arrow on the right.

    Note: You can only rearrange the order of object type tabs if you are in a tabbed view. Select the Left-Hand Side Display Style

  4. To save the left-hand side settings as a configuration file, click at the bottom of the window.

    Notes: You can save and load different configurations. This gives you more flexibility when you are working, because you can easily change the display to suit different tasks.


Group Favorite Objects

You can group objects that you use frequently into a tab on the Schema Browser. These different objects can be grouped into one or several folders. Folders are specific to an instance (not a connection or a schema).

Note: The configuration file for this tab is saved as Projects.lst in the User Files folder.

To group favorite objects

  1. Click image\Toad0015.gif on the Standard toolbar to open the Schema Browser.
  2. Select Favorites in the object list in the left-hand side.
  3. Add one or more folders to group the objects:
    1. Click on the Favorites toolbar.
    2. Enter a folder name.
  4. Add objects to a folder.
    To do the following: Complete these steps:
    To search for and select objects
    1. Click on the Favorites toolbar.
    2. Search for objects. Object Search
    3. Highlight the objects you want to add in the Results tab and click .
    4. Select the folder where you want the object.
    To add objects directly
    1. Right-click an object in the left-hand side and select Add to SB Favorites List.
    2. Select the folder where you want the object.

    To add scripts/files

    1. Right-click the folder where you want the item in the Favorites list and select Add Files.
    2. Select the file and click Open.

      Note: Multi-select files to add more than one at a time.

    3. Select the folder where you want the object.


    • To remove objects from a folder, select the object in the Favorites list and click .
    • To empty or remove favorites folders, right-click the folder and select Remove Folder to remove the folder and its contents or Empty Folder to leave the folder in the list but remove its contents.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating