2

I've noticed that whenever I add tables / stored procs / functions / whatever to a sql server database, that it takes a while for the code completion to pick up that they are now part of the database.

This is really annoying since the code completion and syntax highlighting become totally broken in the workflow scenario where you create a table and then start writing queries or whatever that deal with this new object.

Does anyone know how to get the code completion / syntax highlighting engine to update it's view of what is in the database to get rid of all these spurious invalid object name errors?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
chuck taylor
  • 2,476
  • 5
  • 29
  • 46

2 Answers2

6

I understand that it's too late to answer the question but maybe it will help someone.

You can refresh the Intellisense cache with Ctrl+Shift+R, and wait for 5-10 seconds.

Igor Borisenko
  • 3,806
  • 3
  • 34
  • 49
0

A guess: Close and reopen SSMS? Lame and ineffective, and I hope there's a better way.

Philip Kelley
  • 39,426
  • 11
  • 57
  • 92