Inserting Suggestions

When you are typing a query, SQL Complete offers relevant suggestions to complete the typed words and speed up query typing. You can see a suggestion box with the list of suggestions, that are most relevant to the typed symbols and context. For example, if you type:

  • USE(press Spacebar) - the list of available databases is displayed.

    Suggestion list for USE statement

  • SELECT * FROM AdventureWorks.Person - the list of tables and views of the selected schema is displayed.

    Suggestion list for the SELECT * FROM statement

  • SELECT ProductCategoryID, Name FROM Production.ProductCategory JOIN - a full JOIN statement that is based on foreign keys is suggested.

    Suggestion list for JOIN

  • SELECT ProductCategoryID, Name FROM Production.ProductCategory JOIN ProductSubcategory ON - conditions that are related to column names are suggested.

    Suggestion list for JOIN ON

Suggestions for JOIN statements are filtered by table names (for full statements) or by column names (for conditions).

Note

Suggestions for JOIN statements are shown in the beginning of the suggestion list, but they are not highlighted. Instead the first table or column with the name that matches what is being typed is highlighted. But if the suggested statement or condition is appropriate for you, you can select it by using the up and down arrow keys and insert it by pressing Enter.

To insert a suggestion into code:

Navigate to a required suggestion in the list and press Enter. To close the suggestions box without inserting any suggestion, press the Esc key.

To navigate to a required suggestion in the list:

Use the Up and Down arrow keys to move one item back or forward in the list of suggestions. To scroll the list one page at a time, use the Page Up and Page Down keys.

To re-size the suggestion box:

Drag the right bottom part of the suggestion box to re-size it. The suggestion box will keep the size during your session.

To turn on the semi-transparent mode for the suggestion box:

To see the query text without closing the suggestion box, press and hold CTRL to make it transparent.