Environment

Show Start Page on application startup

When the application starts the Start Page is shown providing quick access to recently used files, visualizers, and wizards. If you do not wish this window to open leave this unchecked.

Visual appearance

This allows you to change the appearance of SQL Visualizer's user interface.

Items shown in File recently used list

This specifies the maximum number of items to show in the File menu's Recent Files list.

Item shown in Windows recently used list

This specifies the maximum number of items to show in the Windows menu's Recent list.

Expand Workspace node on application startup

When the application starts the root Workspace node will expand and show the content immediately within it. If you prefer to have the Workspace node unopened leave this unchecked.

Track active query in Workspace

Whenever you open a query or switch query windows the Workspace will synchronize with the database the query is connected to. This can provide quick access to those objects the query is most likely to use. If you do not want the Workspace to track the active query uncheck this option.

Ignore when in the current database

This option is available only when Track active query in Workspace is ticked. Tracking the active query changes the selected item in the Workspace to the database the query is connected to. However, this may not be desirable when opening several queries against the same database, every time you change query the selected item would change back to the database. By selecting this option the currently selected item will not change when the active query is against the same database, only when a query that is against a different database is selected will the Workspace reflect that.

Show database objects in Workspace

When checked the Workspace will show database objects, such as tables and columns. When unchecked a simpler list of only object types is displayed. When in this mode you can open an Object View to list the available objects.

Navigation Appearance

This specifies whether the navigation area on the left of the application appears in an Outlook style or using tabs.

General

Show system objects when page is opened

When an Object View window is opened the list only show user objects and you must manually change the option to show system objects. By checking this option the View System Objects option will automatically be checked and system objects will be displayed in the list.

Query

Connection time-out

This indicates the number of seconds before a non-responsive connection to the database should time-out.

Command time-out

This indicates the number of seconds before a non-responsive query should time-out.

Show Execution targets

When checked the Execution Targets window is shown against queries allowing you to execute against multiple databases. When this option is not set the queries always run in single database mode so that option is always set.

Single database mode

When set queries will execute against a single database, when not set you can select multiple database to execute against.

Date format

This allows you to customize the way dates are displayed in the results grid. E.g. to display US date format use MM/dd/yyyy. You can also show the time, e.g. HH:mm:ss

Basic format values:

yyyy – 4 digit year
yy – 2 digit year
MM – 2 digit month
MMM – Abbreviated month e.g. Aug
MMM – Full month e.g. August
dd – 2 digit day
HH – 24 hour hours
hh – 12 hour hours
mm – 2 digit minutes
ss – 2 digit seconds

Use fixed width font in query results grid

By default the results grid uses a proportional font. Because of the way proportional fonts work it may sometimes be difficult to determine if the text contains spaces or whether the font is just widely spaced. By checking this option the grid will use a fixed width font.

Use CheckBoxes for BIT values in results grid

This option allows you to show check boxes with a tick for 1, empty for 0 and a grey block for null. If you prefer to have the values 1, 0 and NULL uncheck this option.

Auto-size columns after execution

When checked this automatically resizes the columns in the results grid when a query is executed.

Because resizing columns may take some time to complete the Maximum rows value sets a threshold at which the resize will be disabled.

Include column name when generating SQL IN clause

When checked the current column name will be added to the IN clause generated from the results grid, e.g. EmployeeID IN (1, 2, 5, 10). When unchecked the column is not included e.g. IN (1, 2, 5, 10).

Double click action

This specifies what action is carried out when you double click on a cell in the results grid.

Show extended ToolTips

When checked you can hover over query tabs to get a tool tip of the query in that window. This allows you to get a preview of the query without switching windows.

The Maximum Length value specified how many characters are displayed in the tool tip.

Show line modifications

When checked line modifications are displayed as you change, save, and execute queries.

Change entire document case when nothing selected

Usually when you change case the selected text is used, if no text is selected nothing happens. By checking this option when no text is selected the entire document is changed.

Allow read-only query files to be edited

When not checked a read-only file cannot be edited. When checked attempting to edit a read-only file will prompt you to change the file's read-only status.

Member Assistance (Premium Edition Only)

Show object type filter

This option will display Member Assistance in 2 stages; first a list of object types is presented. When you select one of the types another list containing only that type will be displayed.

Show simplified list

When checked the Member Assistance list will only show the most commonly used keywords, data types, and system functions. Uncheck to get the full list. N.B. This option does not affect the list of database objects which is the same whether the option is enabled or not.

Show objects only

When checked the Member Assistance list will only show object types, excluding keywords, data types, and system functions.

Show Quick Info on mouse hover

When checked if you hover the mouse over an object such as a table name, the Quick Info tool tip will be displayed. If you find this distracting you can turn it off and invoke the Quick Info tool tip manually.