Use this page of the Options dialog to specify some general display and behavior options to use in the SQL Editor.
To set general editor options
Select Tools | Options |Editor | General.
Review the following for additional information:
Background |
Select a background color to use in the Editor. To create a custom color, select the Custom tab in the color palette. Then right-click in one of the empty squares (bottom rows) to open the custom Color dialog. |
Apply connection color |
Select this checkbox to use the connection category color as the background color in the Editor. Default: Cleared |
Enable bracket highlighting |
Select this checkbox to highlight the matching bracket if a bracket is selected with the cursor. Default: Cleared |
Show indicator margin |
Select this checkbox to create a margin on the left side of the Editor. Default: Selected |
Show line numbers |
Select this checkbox to display a line number in the left margin. Default: Cleared |
Show whitespace glyphs |
Select this checkbox to display the glyphs. Default: Cleared |
Show end-of-line glyphs |
Select this checkbox to display glyphs in the end of each line. Default: Cleared |
Show line modification markings |
Select this checkbox to add a bar in the left margin that indicates that a line has been modified. Default: Selected |
Show indention guides |
Select this checkbox to use vertical lines to indicate the amount of indention for text. Default: Selected |
Show delimiter strip after |
Select this checkbox to use vertical line to indicate the preferable length for the row (in characters). |
Default language |
Select the default language to use for syntax highlighting if the file does not have a connection or a known extension. Note: This option applies only when opening a file in a new Editor window. If a file with an unknown extension is already open in an Editor and you select a default language, the language is not applied to the open file. Default: SQL |
File encoding type |
Select the default type of encoding to use when saving files. Note: You can manually change the encoding type for an individual file by right-clicking the Editor window and selecting Character Encoding Default: Windows system settings |
Use individual connection for each open editor |
Select this checkbox to create a separate database connection for each Editor (the first time you execute a statement) and a separate database connection for each Data tab in the Database Explorer (the first time you select the tab and data is queried). The database connection for each Editor and Data tab remain open until you close the associated window; however, the connections remain in an inactive state if a statement is not currently executing. If cleared, all open Editors and Data tabs share the same database connection when the connection is inactive. See Understand Toad Connections for more information. Note: Although you can share a database connection, any commits apply to the selected window only. Default: Selected |
Use Large Script Mode for files larger than (KB) |
Select this checkbox to disable the following features when loading files that are larger than 2 MB:
Default: Selected |
Refresh Object Explorer after executing Create/Drop DDL |
Select this checkbox to enable auto refresh of the Object Explorer after a Create or Drop DDL statement is executed. Clear this checkbox to disable auto refresh after Create/Drop DDL statement execution. Default: Selected |
Tips:
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. See About Options for more information.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center