Tuesday, 1 November 2011

SQL Server Management Studio Intellisence not refreshing on schema change

When I have been adding tables, columns etc, I've noticed that the intellisense is not updated with in the query window. The intellisense is updated however if I shutdown the management studio and re-open it. This is quite an agressive and time consuming measure.

The problem it that objects are cached in the solution so to you have to refresh the local cache.

Edit  -> Intellisense -> Refresh Local Cache (CTRL+Shift+R)

No comments: