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

Question

I am trying to create a Stored Procedure for a newly created database. However, the SQL Server Management Studio Intellisense does not recognize more than half of the tables which had been created.

For example, whilst in the left-hand column below the tables, I have one of the tables called as dbo.Room, when I am typing "dbo." in the new query window, that table is not listed, in fact, only 17 out of 37 tables are only listed.

I cannot see any difference between the tables listed by intellisense and those not. If I am manually typing dbo.Room, it is underlined, with an error of

Invalid Object Name 'dbo.Room'..

Did I miss something in setting up the tables?

Answer 1

The solution is:

• Click the menu Query,
• then click on 'Change Database'.
• Select your appropriate database name.

That's it.

If you want to learn more about SQL, Check out this SQL Certification by Intellipaat.

For more information visit :

Answer 2

Have you check which database is currently pointing on your SQL Management studio?
If you are not sure, add to your stored proc  the 'use <database name>' statement