Take the 2-minute tour ×
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.

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

1 Answer 1

up vote 17 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
    
I knew it had to be something simple. Thanks! I'll accept as answer as soon as the timer lets me. Nice link, by the way. –  Head of Catering May 18 '12 at 15:35
    
+1 Honestly, I didn't know about this until today. I just kept ignoring this because I know for a fact the table is there. –  MarlonRibunal May 18 '12 at 17:38
    
@AaronBertrand: It looks like this answer pushed you past 10K in points. 10K look way more impressive than 9,000 and change. Kind of like have 1 big reserve ship instead of 4 little ones in Galaga. Nice job. –  Head of Catering May 18 '12 at 18:19

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.