Answered by:
SQL Server 2008 Intellisense update/refresh on schema changes

Question
-
Hello,
Using SSMS since RTM release and it seems like a great upgrade. The intellisense is a great new feature but I am having a bit of trouble with it.
If I make any change (new table, column name change, new udf, sp, etc) while SSMS is open those changes are not reflected in current or even new Query editor windows in that instance of SSMS. I can get the new details by closing out SSMS and launching again. It seems that the intellisense data is built and cached at some point and I cannot find any method for refreshing it.
If I am working in SSMS with open query editor windows then make a change - what is my best way to get that to into the intellisense cache? Is closing out SSMS the only way - or is there a less drastic way?
I have tried combinations of the following and none seem to work:
Opening new query windows
Refreshing the object explorer at different levels (table, database, server)
Enabling/Disabling intellisense from the query window toolbar
Enabling/Disabling intellisense from the Tools->Options menu
Please let me know if there is a workaround for this.
Thanks!
Sam
Tuesday, August 12, 2008 11:55 PM
Answers
-
Actually this is because Objects are cached. You can refresh cache using
Edit -> Intellisense -> Refresh Local Cache (CTRL+Shift+R)
Hope this help.
Wednesday, August 13, 2008 3:41 AM -
Devpal is correct. The refresh should fix your issue.Wednesday, August 13, 2008 6:07 PM
All replies
-
Actually this is because Objects are cached. You can refresh cache using
Edit -> Intellisense -> Refresh Local Cache (CTRL+Shift+R)
Hope this help.
Wednesday, August 13, 2008 3:41 AM -
Devpal is correct. The refresh should fix your issue.Wednesday, August 13, 2008 6:07 PM
-
Wednesday, August 13, 2008 11:32 PM
-
Thank you very much for your solution, it works perfect :DThursday, December 10, 2009 3:36 AM
-
Many thanks from here too.Sunday, January 9, 2011 6:36 PM
-
Wow........Perfect Work.....
Thanks dear frd....
Thank you very much......
Wednesday, February 16, 2011 1:21 PM -
Thanx ChampWednesday, March 9, 2011 4:46 AM
-
Works PerfectTuesday, June 14, 2011 6:59 PM
-
Thanks, very helpful!Friday, December 16, 2011 7:36 PM
-
Hi,
Check and Try this -
https://arulmouzhi.wordpress.com/2019/11/13/refresh-enable-disable-intellisense-in-ssms/
Friday, January 17, 2020 3:09 PM