Using and Configuring Code Completion Suggestions (Quick Ref)
Published 09 September 2019
Following are the main elements and behaviour of the code completion feature, all of which you can configure using the Prompt Options menu:
- Suggestion box – automatically provides auto-completion suggestions for the columns and tables you wish to access, will help fill in JOIN conditions, GROUP BY clauses and more. For columns, the suggestion box also provides a column picker with a list of available columns and their data types.
- In Suggestions > Behavior, uncheck Automatically show suggestions after… to see suggestions only on demand (using Crtrl+Space), or else adjust the frequency of suggestions.
- Use Suggestions > Connections to control the databases and schemas for which suggestions are made
- Use Suggestions > Join conditions to specify the criteria for suggesting JOIN
- Object definition box will (optionally) appear automatically when you select a suggestion. It has a Summary tab listing the column names, data types and nullability, and a Script tab showing the object creation script, which you can copy.
- Disable/enable using Show object definitions in Suggestions > Behavior
- Object Tooltips – hover the mouse over any existing object to see its object definition box in a tooltip. For some objects these are clickable links.
- Disable/enable using Show tooltips for in Suggestions > Behavior
- Dependencies tooltip – For columns, clicking on the tooltip will show all the objects referencing (using) the column and being referenced by the column.
- Disable/enable using Show tooltips for in Suggestions > Behavior
Code Completion Keyboard Shortcuts
Action | Shortcut |
---|---|
Refresh Suggestions | Ctrl+Shift+D |
Toggle Suggestions On/Off | Ctrl+Shift+P |
Show Suggestions | Ctrl+Space |
Switch to/from column picker | Ctrl + Left arrow / Ctrl + Right arrow |
Move up/down suggestions list | Up arrow / Down arrow |
Move up/down the suggestions box filters | Ctrl + Up arrow / Ctrl + Down arrow |