The IntelliSense feature of SSMS in SQL 2008 is a handy feature, overall I really like it. There was one thing that was bugging me though: If I made any schema changes while SSMS was open, Intellisense didn’t seem to know about it. It would mark any references to those changes as invalid. The sql would still run, mind you, it was just annoying seeing red squiggly lines everywhere.
Well it seems IntelliSense has its own little cache in SSMS and you need to refresh it with the current metadata information. This can be done by going to Edit -> Intellisense -> Refresh Local Cache or by hitting CTRL-Shift-R.
Just thought I’d share that here in case anyone else was running into the same problem.