CODEWITHSUNDEEP
sqlsql-server
Sergio Tapia
Sergio Tapia

Reputation: 41128

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?

alt text

Upvotes: 28

Views: 76117

Answers (7)

Apeksha Shetty
Apeksha Shetty

Reputation: 11

Okay first try to refresh tables if that doesn't word then just above the object explorer there is an drop down box it should have name of the database you have given earlier.. sometimes it will have default value master so check it and if its master there click on drop down box and select the name of database and then click excute and refresh table now the table should appear..

Upvotes: 1

A_N
A_N

Reputation: 1

Refresh the "Tables" in your current database. It works. Right Click on "Tables" and click on "Refresh"

Upvotes: 0

Yuresh Karunanayake
Yuresh Karunanayake

Reputation: 567

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

Upvotes: 4

Aki
Aki

Reputation: 179

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

Upvotes: 1

M3nd3z
M3nd3z

Reputation: 316

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.

Upvotes: 1

marc_s
marc_s

Reputation: 754268

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

Upvotes: 14

Svetlozar Angelov
Svetlozar Angelov

Reputation: 21660

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

Edit -> IntelliSense -> Refresh Local Cache

Upvotes: 72

Related Questions