Like most applications, Preferences or Options enable the user to make changes to the default configuration to suit the way they work. The same is true for Toad but there are so many, for some it can be a bit of a challenge finding what they are looking for.
 
The objective of this blog is to help you get a handle on what the main options are that you probably need to know about.  Note that the screen captures were done using Toad for SQL Server, but these techniques apply to Toad for DB2, Toad for MySQL and Toad for Data Analysts, too.

Some Toad Options are set during the Toad installation and others via the Configuration Wizard. The Configuration Wizard can be reconfigured at any time and is found under the main menu, Tools | Configuration Wizard.   

  

The first screen will let you pick one of several preconfigured layouts. For instance, if you have used Toad for Oracle in the past and prefer the layout (workflow) of that tool, you can simply select it here and you are done. This will make Toad mimic the layout of that tool (keyboard mappings included). However, if you prefer to customize the layout, choose “Custom” and click next. 

  

On the following screen you will be presented with several choices to configure the look and feel of the windows and grids. Here you can change colors, contrast and more. The Configuration Wizard preview window will update with your changes to give you a glimpse of what each style really looks like.

The next screen in the wizard is where you can choose a default style for your Database Explorer and Object Explorer. The default is to divide objects by their type and display them on separate tabs; if you prefer a tree-list or stacked tabs, this is where you can change that.

The final configuration page controls which window automatically opens when connections are made: Database Explorer, Editor, or Query Builder.

  
 
The next portion of this document will focus on Toad Options, found under the main menu selection, Tools | Options, and the following folders: Environment, Explorer, Editor, and Database. 

Environment-General - This page of options influences how Toad opens. Users can select the default web browser home page. Croak options allow users to mute or enable the sound Toad makes when starting, or after completing certain tasks. There is also an option to Show the connection dialog on startup. If a user has marked the ‘Connect on Startup’ selection in the Connection Manager, then having this option unchecked will skip the connection window during startup.

  
 
Environment-Grid - This page of options influences the data grid display for data grids that exist throughout Toad. Many of these options are selected by default such as allowing filtering, sorting, and grouping. Line numbers is not checked by default but a helpful option to have selected. There is also a Read-Only option that would prevent data changes even if you had permissions to update data. At the top right of this page, there are different choices for the format display for DateTime, Number, Integer, and Money.
 
  
 
Explorer-Objects - This page allows users to customize the object types displayed in the Object Explorer. The check box in the Visible column will hide or unhide that object type from the Navigation Tree. If a user does not work with certain object types, they can hide them in the Object Explorer. The display order of the objects can also be customized, with the up and down arrows on the right side.
 
  
 
Editor- General - This folder has a few pages worth exploring, since most users will spend a lot of time in the Editor. The General Page has settings for Font, Show Line Numbers, Color Coding for modifications, and Word Wrap settings.
 
  
 
Editor-Tools- A popular Toad Editor feature is the SQL Command Recall (Editor Main Menu/ Add to SQL Recall). The number of SQL saved by Toad is controlled by this Options setting. By default it is at 100, which can be increased or decreased with the SQL Recall setting. (A helpful tip within the Editor: Ctrl + up or down arrow, will scroll through the SQL Recall list). There is also a drop down window for the display preference for SQL execution plans.
 
  
 
Database-General- This page has setting for the number of rows initially brought back in the data tab. Notice there is also a check box to ‘Apply to Editor’. A user can always retrieve more data, or the whole data set, after the initial data fetch. There is a setting for reopening lost connections. In the Configuration Wizard, there was a choice for ‘Open on New Connection’, and this is also controlled in this window.
 
  
 
Database-Script Result- This page has an option that controls how multiple data sets are displayed in the bottom half of the editor, with choices for ‘All in one tab’, or individual tabs for each result set.

Exploring these settings should make your experience using Toad more beneficial. For more detailed information on every Toad Option, please see Help Menu | Contents-Configure Options.