I create local temp tables and query from them often in my script. In my previous installations of SSMS with (and without) SQL Complete, I was able to write "SELECT * FROM #" and would receive suggestions for available temp tables to query, including ones I created earlier in the script.
I recently received a new laptop and of course installed SSMS and SQL Complete. All other features appear to work as intended. Intellisense/Suggestions would provide suggestions for database tables as expected, however, this installation of SSMS and SQL Complete fails to provide suggestions for local temp tables only. Unfortunately I use temp tables in my scripts often, so this is pretty inconvenient to have not working as it had previously.
Relevant settings:
- Code Completion enabled (works as expected for non-temp tables)
- SQL Complete > Suggestions > Suggestions not loaded for tempdb tables
- This setting is set to the same setting in my old laptop which does provide suggestions for my locally created temp tables
- Enabling suggestions for tempdb tables still does not provide suggestions for my locally created temp tables
- Edit > Intellisense > Toggle Completion Mode enabled
One thing I noticed is that typing "SELECT * FROM dbo.#" does in fact provide suggestions for my locally created temp tables, but I find that strange since I didn't have to do that on my old laptop (same SSMS and SQL Complete version). Ideally, I would like to have it how it was before and not have to type the dbo schema to get temp table suggestions.
Is there a setting I'm missing to get this configured so that it works the same way that it did previously, where I can type "SELECT * FROM #" and SQL Complete provides suggestions for locally created temp tables?
SSMS version 19.3.4.0
SQL Complete version 6.16.4
Thanks in advance!
EDIT: Removed whitespace from post.