CODEWITHSUNDEEP
sql-serverssms
chuck taylor
chuck taylor

Reputation: 2516

sql server management studio code completion

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?

Upvotes: 2

Views: 2062

Answers (2)

Igor Borisenko
Igor Borisenko

Reputation: 3866

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.

Upvotes: 6

Philip Kelley
Philip Kelley

Reputation: 40319

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

Upvotes: 0

Related Questions