When you are typing a query, dbForge SQL Complete offers relevant suggestions to complete typed words and speed up query typing. You can see a suggestion box with a list of suggestions, most relevant to the typed symbols and context. For example, if you type:
- USE(press Spacebar) - the list of available databases will be displayed.
- SELECT * FROM AdventureWorks.Person - the list of tables and views of the selected schema will be displayed.
- SELECT ProductCategoryID, Name FROM Production.ProductCategory JOIN - a full JOIN statement that is based on foreign keys will be suggested.
SELECT ProductCategoryID, Name FROM Production.ProductCategory JOIN ProductSubcategory ON - conditions that are based on column names will be 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 Escape 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 refresh the list of suggestions:
In the top menu select SQL Complete -> Refresh Suggestions. The list of suggestions will be reloaded. (While composing a query, it is useful to refresh the list of suggestions to make sure that it displays all the objects that might be added by other database users.)
To resize the suggestion box:
Drag the right bottom part of the suggestion box to resize it. The suggestion box will keep the size during your session in SSMS.
To turn on the semi-transparent mode for the suggestion box:
To see the query text without closing the suggestion box, you can make it transparent. Press and hold on Ctrl while you are examining the query text.
See Also