Sql – How to make SQL Management Studio see new table

sqlsql-server-2008ssms

I am using SQL server 2008. If I am working on the Management Studio's query analyser, and I go ahead and create a new table or view, then the SSMS does not see the newly created object for intellisense.

What do I do to make SSMS see and autosuggest from the newly created tables/views too?

Best Answer

Have you tried to refresh the intellisense cache

Edit -> Intellisense -> Refresh Local Cache (CTRL+Shift+R)