Options dialog: Editor tab

This tab allows you to configure the appearance of text typed in the SQL Statements pane.

The Editor tab of the Options dialog in Interactive SQL consists of four tabs: Editor, Tabs, Format, and Print.

Editor tab

The Editor tab has the following components:

Vertical scroll bar Shows or hides a vertical scroll bar when the window is too small to contain all the text.
Horizontal scroll bar Shows or hides a horizontal scroll bar when the window is too small to contain all the text.

Tabs tab

The Tabs tab has the following components:

Tab size Lets you set the tab size (in number of spaces). The default is 8.
Indent size Lets you set the size of indents (in number of spaces). The default is 4.
Insert spaces Inserts n spaces when you press Tab instead of inserting one tab character. The value for n will be between one and the number of indent size spaces, depending on how many spaces are required to move the cursor forward to the next tab stop. This is enabled by default.
Keep tabs Inserts a tab character into the document and moves the cursor forward to the next tab stop when you press Tab.
Auto indent Lets you set the auto indent feature. You have the following options:
- None disables the feature. This is the default.
- Default uses the tab and indent sizes that are set.
- Smart uses previous lines of code as a guideline for indenting open and closing braces.
  - Indent opening brace Select this option if you wish opening braces to be indented. This option is enabled when the Smart option is selected.
  - Indent closing brace Select this option if you wish closing braces to be indented. This option is enabled when the Smart option is selected.
Sample The Sample field shows an example of how code is formatted based on the options you choose for indenting opening and closing braces.

Format tab

The Format tab has the following components:

Text Highlighting Lets you specify the color and style of different types of text in the main editing window. Choose a type of text and then set the foreground, background, and style for that text type.
- Foreground Foreground refers to the color of the text.
- Background Background refers to the color of the screen behind the text.
- Style Lets you specify the type of formatting for a text type. You have the following choices:
  - Plain
  - Italic
  - Bold
  - Italic and Bold
Font size Lets you specify the font point size of the text that appears in the SQL Statements pane. The default is 12.
Caret color Lets you specify the color of the blinking on-screen cursor indicator.
Sample Shows an updated sample of the text with the settings you configure above.
Reset All Returns all settings to their default values.

Print tab

The Print tab has the following components:

Header Lets you specify what information appears in the header, as well as how it is formatted, when you print the contents of the SQL Statements pane. The header text is left aligned by default. Press the > button for a list of available options.
Footer Lets you specify what information appears in the footer, as well as how it is formatted, when you print the contents of the SQL Statements pane. The footer text is left aligned by default. Press the > button for a list of available options.
- > button Pressing the > button lets you choose from the following options for the header or footer:
  - File Name
  - File Time
  - File Date
  - Page Number
  - Page Count
  - Current Time
  - Current Date
  - Left Align
  - Center
  - Right Align
  The items that you select do not all need to have the same alignment. For example, you can choose to left align the file name and right align the date in the header. By default, all text in both the header and the footer is left aligned. You must specify the alignment before the type of text. For example, if you want the file name to be centered in the header, type &C&F in the Header field, or press the > button and select the Center option and then press the > button again and select the Filename option.
  
  In addition to specifying these options, you can type text that you want to appear in the header and footer fields. For example, if you type Page &P of &p in the Footer field, Page 1 of 1 appears in the footer of the printed document.
Font size Lets you select the font point size for the printed text. The default is 12.

Text completion tab

Interactive SQL provides a text completion option that can supply object names for you. You can configure text completion to fill in the name of any or all of the following object types: tables, views, columns, stored procedures, and system functions.

To use text completion:

In Interactive SQL, type the first letter of a database object name in the SQL Statements pane.
Press Ctrl+Space or Ctrl+Shift+Space.

A window appears listing the names of database objects that begin with the letters you have typed so far.

If you do not see the object name you want, press Tab to view a complete list of database objects. By default, all database objects appear in the list.

The object name appears in the SQL Statements pane.
Select the object name from the list and then press Enter.