Options - Intellisense

These options govern the behaviour of the Intellisense feature of the Run SQL window.

Show Tables Dropdown

Specifies whether the table-list dropdown will automatically be displayed as the user types.

If this option is switched off, the table-list dropdown will only be shown when the user hits Alt+T.

Show Columns Dropdown

Specifies whether the column-list dropdown will automatically be displayed as the user types.

If this option is switched off, the column-list dropdown will only be shown when the user hits Alt+C.

Show Column Values

Specifies whether column values are to be displayed as the user types. This is triggered when the user types an equals sign after a column name.

This option should only be used when you are dealing with tables with a small number of rows. AQT runs a query to get this list of values; this can be time-consuming for large tables.

This option is de-selected by default.

Show Keywords when Tab is pressed

Specifies whether the list of Keywords is displayed when the user hit the Tab key.

If this option is switched off, the Keyword list will only be shown when the user hits Alt+K.

Max Dropdown Items

Specified the maximum number of items in the intellisense dropdown box. Without a limit, the dropdown could be populated with tens of thousands of table names; this can cause a performance problem.

Edit Keywords

This allows you to edit the Intellisense keyword file. These keywords are those that appear in the keyword-dropdown of the Intellisense feature.

Switching Intellisense On and Off

By default, Intellisense is active. You can switch it off and on by clicking on the Intellisense button in the Edit toolbar in the SQL window.