Why is my table not fully recognized by the Query pane in SSMS?

This may be the issue – sometimes Intellisense (the engine that does the underlining etc) takes a bit of time to update.

You can force a refresh with ctrl-shift-r or this button

enter image description here

If the button is not there, I add it to a toolbar

  • On the right side of the toolbar, click the down arrow and select ‘add or remove buttons’
  • Select ‘Customise’
  • Click ‘Add command…’
  • Choose the ‘Edit’ category
  • Scroll to ‘Refresh local cache’ and select it
  • Move the button to your preferred location on the toolbar
  • ‘Modify selection’ if you want to (say) include text next to the button

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top