Temp Tables: suggestions not showing up
TomT
Posts: 22
I thought this had been resolved, however when working with temp tables, I don't get column suggestions - table variables work fine however.
Version is latest: 4.0.3.10
Version is latest: 4.0.3.10
TomT
Comments
It should work for temporary tables as well.
Can you check whther the following options are checked at your end?
1. SQL Prompt 4 --> Options --> Suggestions --> Types of Suggestion --> List all database columns after a SELECT statement.
2. SQL Prompt 4 --> Options --> Suggestions --> Types of Suggestion --> List System objects.
If this options are selected and you are still encountering the issue can you kindly email us the temporary table creation script and steps to replicate ths issue?
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com