SQL Server. How to refresh the intellisense? [duplicate]

Possible Duplicate:
Lost the IntelliSense
SQL Server 2008 Intellisense problem

I'm new to SQL Server, so this is probably an easy fix. In SQL Server 2008 R2, I've just imported a new data table and/or renamed fields in an existing table (it happens either way). When I start to write some SQL, the intellisense doesn't recognize the new field names and starts underlining everything.

The only fix I've found is to close and reopen SQL Server, but I'm sure there's a simpler solution out there. Suggestions please?

(This isn't a serious problem, just a pet peeve).


Solution 1:

Ctrl + Shift + R will refresh Intellisense.

Solution 2:

If you want to do it via the menus, it's:

Edit / IntelliSense / Refresh Local Cache

Using the keyboard, it's: CTRL-SHIFT-R