New Table not showing up on intellisense -- Sql Server 2008 R2

_{Thursday, October 17, 2013 7:06 PM}

I did a

Select * Into my2ndDB.dbo.tblx  from LocalTblx

I go to my2ndDB and see tblx in the Tables List, but when I write a query in QA I don't see tblx in the intellisense dropdown and I get a red line on tblx -- But I can query tblx in my2ndDB OK.  How can I get tblx to show up in the intellisense in my2ndDB?

Thanks

Rich P

_{Thursday, October 17, 2013 7:09 PM ✅Answered}

The Intellisense data is cached.  Please see:

http://blog.sqlauthority.com/2013/07/04/sql-server-how-to-refresh-ssms-intellisense-cache-to-update-schema-changes/

_{Thursday, October 17, 2013 7:09 PM ✅Answered}

Rich,

You can either choose edit->intellisense->refresh local cache or press control + shift + R

-Sean

Sean Gallardy | Blog | Twitter