Refresh Intellisense Cache in Microsoft SQL Server Management Studio

When you create a new object in SSMS, its intellisense will not recognize it right away. I had to close and re-open the SSMS to make it see these new objects.

Well, there’s a very nice shortcut to make SSMS see these new objects right away! Press Ctrl+Shift+R to refresh the Intellisense cache after you’ve created a new object and everything will be fine.

PS to those fellas using Red-Gate SQL Prompt:
Don’t forget to press Ctrl+Shift+D refresh SQL Prompt’s cache either.

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>