SQL Server. How to refresh the intellisense?

sql-server sql-server-2008 ssms
PowerUser picture PowerUser · Oct 19, 2011 · Viewed 87.1k times · Source

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

Answer

user596075 picture user596075 · Oct 19, 2011

Ctrl + Shift + R will refresh Intellisense.

Related questions

SQL Server 2008: how do I grant privileges to a username?

I need to be able to establish an ODBC connection through SQL Server authentication. In SSMS how do I grant permission for a user to be able to have ALL RIGHTS on a specific database? is there a way to …

Read More
How to drop all tables in a SQL Server database?

I'm trying to write a script that will completely empty a SQL Server database. This is what I have so far: USE [dbname] GO EXEC sp_msforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT all' EXEC sp_msforeachtable 'DELETE ?' When I run …

Read More
The request failed or the service did not respond in a timely fashion?

I have the following error while I connect to SQL Server 2008 Management Studio with Windows authentication. "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details." …

Read More