Tables don't show up in query editor


I'm developing with sql server 2008 express. When I create a new table the table doesn't show up directly in the query window when I create a query with intellisence activated. Older tables are there but it takes al long time (often a day or so) until the newly created tables show up for intellisence in the query window.

I've tried to refresh the tables view and also gone to Edit/Intellisence/Refresh Local Cache, but still they don't show up until a long while later. I also restarted the service for sql server without result.

How can I make them available directly instead of hours later.

Peter NordbergIT ManagerAsked:
Who is Participating?
dbaSQLConnect With a Mentor Commented:
apparrently this is somewhat of a 'feature'.  surprises me, though, that the refresh doesn't get it for you.  is that what you're saying?  see here:

right-click on the Tables and Select Refresh, or hit Ctrl-shift+R, to refresh intellisense
Peter NordbergIT ManagerAuthor Commented:
Hi and thanks foir answer,

As I said above I've already tried both those options already, but that doesn't solve it.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.