SQL Management Studio won't recognize a table exists after scripted create

Press Ctrl-Shift-R to refresh the intellisense.


If you prefer, you can use the menu to refresh the cache:

Edit>Intellisense>Refresh Local Cache

The good thing using the menu, is that you will learn some new Intellisense hot-keys...

SQL Server Management Studio Intellisense doesn’t work after schema changes


You probably did what I always do. I often create a table while connected to the wrong database, or the default database. For me, the default database is 'master' so I have a lot of garbage in my master DB :)

Randy


I right-click on the Tables and Select Refresh from the context-sensitive menu (Ctrl-R works too)