274

Possible Duplicate:
Lost the IntelliSense
SQL Server 2008 Intellisense problem

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).

starball
  • 20,030
  • 7
  • 43
  • 238
PowerUser
  • 11,583
  • 20
  • 64
  • 98

2 Answers2

500

Ctrl + Shift + R will refresh Intellisense.

Anis Alibegić
  • 2,941
  • 3
  • 13
  • 28
  • 14
    You need to have focus on the query window, else this menu item will not appear and Ctrl+Shift+R won't work. – Luke Sep 25 '14 at 10:24
  • This intellisense functionality is broken with SQL Server Management Studio version 10.50. It works in 11.0+. – JustBeingHelpful Oct 29 '15 at 18:31
  • In other words, in SQL Server Management Studio (SSMS) 2008, it's broken. In SSMS 2012, intellisense works. So if you need to connect to MSSQL 2008, just upgrade the IDE to 2012. – JustBeingHelpful Dec 04 '15 at 21:38
  • 4
    Worth a mention. Ctrl + Shift + R does not always work. Sometimes you have to restart SSMS. – Derpy May 20 '16 at 18:40
  • 11
    If you have **SQL Prompt** installed, the shortcut is **Ctrl + Shift + D** or, using the menu, **SQL Prompt > Refresh suggestions**. – Joe B May 18 '17 at 16:07
  • This didn't work for me, but right-click "Intellisense Enabled" (to disable it) then repeat (to re-enable it) did work for me. – Steve Mar 18 '22 at 08:35
138

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

Edit / IntelliSense / Refresh Local Cache

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

Michael Goldshteyn
  • 71,784
  • 24
  • 131
  • 181