Intellisense won't recognize temp table RRS feed

  • Question

  • I open a new query in ssms and create a global temp table. I then open a new query window in ssms and write sql to insert data in the fields. But in the new query window intellisense does not recognize the temporary table. The sql works fine and the data is inserted into the temp table and I can work with the temp table but without intellisense. I can return to the original query window where the table was created and intellisense work fine. I have tried refreshing intellisense, it doesn't work. Any suggestion will be appreciated.
    Thursday, June 22, 2017 3:07 PM

All replies

  • That's quite normal that SSMS don't know about newly create objects. Try menu "Edit" => "IntelliSense" => "Refresh local cache".

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Teige Gao Tuesday, June 27, 2017 9:53 AM
    Thursday, June 22, 2017 4:06 PM