Insert suggestions for code completion

Last modified: October 1, 2024

When you are typing a query, dbForge Studio for SQL Server 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.

  

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

  

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

  

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

  

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.