I'm trying to develop a stored procedure for a brand-new database. More than half of the produced tables are not, however, recognized by the SSMS IntelliSense. For instance, I have a table called dbo in the tables section on the left-hand column. In the new query box, Room, when I type "dbo," that table is not listed; in fact, only 17 of the 37 tables are listed.
The tables given by IntelliSense and those not are identical in my eyes. When I manually enter dbo.Room, it is underlined and displays an error message:
Invalid Object Name 'dbo.Room'..
Have I missed something in setting up the tables?