CODEWITHSUNDEEP
sql-serverssms
B. Clay Shannon-B. Crow Raven
B. Clay Shannon-B. Crow Raven

Reputation: 10287

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

I created a new table (MOVIES_SINGLETABLE) as part of my Flix4Fams database. The table appears in the list of tables, but in the query pane it is not recognized (as seen by the squiggly lines under its name):

enter image description here

Also, it does come up in the list of table names:

enter image description here

Yet, when I run the query against it, I get no err msg that the table does not exist. It should have records, but it says there are none. Why is it being treated like a "red-headed stepchild"?

It's accepted, in a sense, but not completely.

Upvotes: 0

Views: 668

Answers (1)

seanb
seanb

Reputation: 6685

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

Upvotes: 1

Related Questions