Why Are My Tables Not Showing Up In SQL Server Management Studio's Intellisense?

I can't pull up my tables so I can use them in my stored procedure. Any reason why they aren't showing?

Solution 1:

Have you just created them? Intellisense data used by it is cached. Try to refresh it

Edit -> IntelliSense -> Refresh Local Cache

Solution 2:

Have you done a "Edit > Intellisense > Refresh local cache" lately??

Keyboard shortcut: Ctrl + Shift + R

After adding lots of tables, intellisense gets out of sync at times...

Marc

Solution 3:

Right click on the 'Tables' and select 'Refresh'

Solution 4:

For those using SQL Server Management Studio 2016 you simply need to hit 'F5' or go to 'View > Refresh' and your recently added tables should appear.

Solution 5:

If any of the above answer is not working for you, then

Expand your database >> Security >> Users >> double click user.

Under 'Select a page' >> Membership >> Make sure db