The first entry in the suggest list dropdown should chosen automatically
The first entry in the suggest (intellisense) list dropdown should chosen by default.
This will speed up my typing as the 1st word at the top is typically is the best fit, but to chose it I need to move my mouse or the down arrow key to actually choose it.
This is governed by the option ‘Select items in the list if a user input is expected’ that is in the ‘List Members’ branch of the ‘Options’ window (select ‘SQL Complete → Options…’ from the main menu).
-
Phill Gee commented
it works for me when selecting a table but when typing in the join, the top row isn't selected so I can't even hit the tab key to get it to work.
-
Sheldon commented
@Arthur, try SSMS > Edit Menu > Intellisense > Toggle Completion Mode.
This completion mode seems to get reset for each session, but if you select it (shortcut control+alt+space), it will do exactly what you are talking about. It would be nice for SQL Complete to preserve this preference among any new windows though!