2,032
2017-08-28 06:56:48
Ctrl + Shift + R will refresh Intellisense.
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).
Ctrl + Shift + R will refresh Intellisense.
You need to have focus on the query window, else this menu item will not appear and Ctrl+Shift+R won't work.
this is a life changing moment, how did I never know this lol
This intellisense functionality is broken with SQL Server Management Studio version 10.50. It works in 11.0+.
Worth a mention. Ctrl + Shift + R does not always work. Sometimes you have to restart SSMS.
If you have SQL Prompt installed, the shortcut is Ctrl + Shift + D or, using the menu, SQL Prompt > Refresh suggestions.