Field

Definition

Enable auto intelli tips

If checked, Intelli Tips will be displayed automatically as you type your SQL queries.

Display delay time in milliseconds

This is the amount of time WinSQL waits after a key is pressed before displaying the Intelli Tips window. This value is in milliseconds

Assign aliases in FROM clause

If checked, WinSQL will assign aliases for tables in the FROM clause. For example, if this NOT checked, the query will look like:

Select Customer.Name
from Customer

When this is checked, the query will look like:

Select c.Name
from customer c

Force quoted identifiers

If checked, WinSQL will always enclose object names in quotes. The generated query will look like:

Select *
From “dbo”.”customer”

When this is NOT checked, WinSQL will only put quotes on objects that have an embedded space in their name.

Enable/Disable Data Lookup

Select one of the following options:

·Disable data lookup: Select this option if you wish to disable Data Lookup. Doing so will prevent the Data tab from appearing in the Intelli Tip window.

·Enable for every column: Select this option to enable data lookup for every column whose data type is one of the following: 1) numeric, 2) Date/time, or 3) character (where the length is less than the specific character length).

·Enable for columns that I choose: If this option is selected, you must specifically assign a SQL query to every column for which you wish to enable data lookup. To assign a SQL query, double-click that column in the Catalog Details window (see Enable for every column, above).

Number of records to display

The number of records to display in the Intelli Tips window. If the query returns more than the specified number of records, they will be ignored.

Max length for character fields

Data lookup is enabled for fields where the column length is less than this value. For example, if there is a remarks field in a table and its size is 255, Data Lookup is not enabled for this field. This value only applies to character types.

Max record count for a table

For large databases, WinSQL Professional may take a long time to fetch records from a table. Therefore, if you specify a value other than -1, WinSQL Professional will only run data lookup queries for table having fewer numbers of rows than what you specify here.