I’m in the process of creating stored procedures for a new database I’ve set up, but I’m facing an issue with SSMS intellisense. It seems to recognize only some of the tables during queries.
Currently, I have a total of 37 tables. In the object explorer on the left, they are all visible, including one named dbo.Room. However, when I type dbo. in a query window, only 17 tables show up in the intellisense suggestions. The Room table isn’t among them at all.
If I manually enter dbo.Room, it gets flagged with a red underline and an error message:
Invalid Object Name ‘dbo.Room’
I’m unsure why some tables are functioning correctly with intellisense while others aren’t. They seem to have the same properties in the object explorer. I’ve refreshed the tables list multiple times, but it hasn’t resolved the issue.
Does anyone have insights on what could be the cause of this problem?