Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Metadata in SSMS isn't updating unless I shut it down and restart. I've tried disconnecting from the server and reconnecting while the SSMS session is active, but that isn't working.

Steps to recreate:

  1. Create a table
  2. Select something from that table
  3. SSMS displays squiggly red lines under it with the tip "invalid object name"
  4. Execute the query

How can I force the metadata to update without restarting SSMS?

share|improve this question
up vote 26 down vote accepted

You need to use this key combination:

CTRL + SHIFT + R

Alternatively, use the menu Edit > IntelliSense > Refresh Local Cache.

This article might also be useful (for future readers who have more perplexing IntelliSense issues):

Troubleshooting IntelliSense in SQL Server Management Studio

share|improve this answer
3  
+1 - OP should bear in mind this runs queries which can be blocked by other DDL. – JNK May 18 '12 at 15:32
1  
Right, I'd make sure your current query windows don't have any uncommitted DDL-related transactions, for example. :-) – Aaron Bertrand May 18 '12 at 15:33

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.