We’ve all been here. You added a new Table to your database, change / add a new column to a table. Once satisfied with your changes, you go to change or create a stored procedure expecting IntelliSense to pick everything up as VS would, but wait… You get a red squiggly for that new column. You check the spelling, you stare at the screen until you start crying because there is no way it’s wrong. So you execute the procedure and it completes successfully.
Wait.. What was that? It worked? Ok so we all hate this as well as the fact that the only real fix is to restart the application. Well, there is a solution. Not the best of all solutions, but a solution.
Apparently, you can clear the local cache by doing the following and everything will be right with the world again.
IntelliSense should be refreshed with the latest changes in database.
a) Press CTRL+SHIFT+R
b) Go to Edit >> IntelliSense >> Refresh Local Cache