Printed 2017/07/26 09:23PM

IntelliSense Slow to Refresh


IntelliSense in SQL Server 2008 can sometimes not be very intelligent.  It’s there to help you can sometimes cause more problems than it does solve problems.  Here’s one of those problems cases:

Create a table without using the UI.  Just type a basic script to create a table.


Try to select from that newly created table and your IntelliSense can’t find the new table.


The problem is SQL Server knows you have a new table but IntelliSense does not.  If you refresh the Local Cache IntelliSense will be back up to speed with you. Go to Edit -> IntelliSense -> Refresh Local Cache


Now it should recognize your newly created table when writing your statement. 

Another best practice with IntelliSense that’s not shown in the second screenshot is when writing statements always write the From statement first.  That way IntelliSense knows which table to display columns for.

Copyright © 2002-2017 Redgate. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.