How to Refresh IntelliSense Cache in SSMS

I recently created a database called “testDB” and when I typed “USE testDB” in the SSMS Query window it gave me a little red squiggly underline (see below snapshot).use database red errorWhy did this happen when I just created a new database? That’s because the local IntelliSense cache hasn’t updated yet.

How to Refresh IntelliSense Cache in SSMS

If you want to force the IntelliSense Cache to update, go to Edit, then IntelliSense, then click “Refresh Local Cache.” (See snapshot below)

refresh ssms intellisense cache

That should refresh your IntelliSense Cache and remove all those annoying red squiggly underlines!

One Reply to “How to Refresh IntelliSense Cache in SSMS”

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.