sql server invalid object name - but tables are listed in SSMS tables list

Question

I am attempting to create a Stored Procedure for a newly created database. However the SSMS intellisense does not recognize more than half of the tables which have been created.

For example whilst in the left hand column under tables I have a table dbo.Room, when I type "dbo." in the new query window, that table is not listed, in fact only 17 out of 37 tables are listed. I can see no difference between the tables listed by intellisense and those not. If I manually type dbo.Room, it is underlined, with an error of "Invalid Object Name 'dbo.Room'.".

Have I missed something in setting up the tables?

UPDATE: I have tried refresh of the tables list (several times)

Answer 1

did you try: right click the database, and click "refresh"

Answer 2

Are you certain that the table in question exists?

Have you refreshed the table view in the Object Explorer? This can be done by right clicking the "tables" folder and pressing the F5 key.

You may also need to reresh the Intellisense cache.

This can be done by following the menu route: Edit -> IntelliSense -> Refresh Local Cache

Answer 3

Try:

Edit -> IntelliSense -> Refresh Local Cache

This should refresh the data cached by Intellisense to provide typeahead support and pre-execution error detection.

Answer 4

Are you using the correct database? I sometimes forget to change the database in the drop down when I am in the query window and usually get this error msg.

Answer 5

Sorry for a late reply, but ctrl+shift+r refreshes intellisense in management studio 2008 as well.

Answer 6

Why there is a need to refresh intellisense anyway? I thought it would refresh itself.