Temp Tables: suggestions not showing up

TomTTomT Posts: 22
edited January 28, 2010 5:06AM in SQL Prompt Previous Versions
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
TomT

Comments

  • Anu DAnu D Posts: 876 Silver 3
    Many thanks for your post.

    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?
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.