Browsed by
Month: April 2011

Refresh local cache for IntelliSense

Refresh local cache for IntelliSense

I have come across many situations where I had a SQL Server query window open and I changed something in my table definitions. This resulted in not being able to use the IntelliSense on those new columns or tables.

In SQL Server Management Studio, you can refresh the IntelliSence cache by pressing Ctrl+Shift+R, or go to Edit – IntelliSense – Refresh Local Cache:
It takes a second or two when the query has been updated, but at least you can use the IntelliSense on your new table and columns without having to close the query window and open up a new one.