CODEWITHSUNDEEP
sqlssms
user4352158
user4352158

Reputation: 729

Saved table not showing up in Object Exploer in SQL Management Studio

I created new tables Faculty and Specialty as described in the link below, but I do not see them under databases in the Object Explorer. Also, if I click on 'edit', I do not see 'Intellisense' anywhere. What is going on?

http://www.cs.trinity.edu/~thicks/Tutorials/MSSQL-Server-Management-Studio-DB-Construction/MSSQL-Server-Management-Studio-DB-Construction.html

Upvotes: 4

Views: 9934

Answers (3)

Henry Wycislo
Henry Wycislo

Reputation: 51

I updated the view that management studio uses to display table information.

  1. Create your table
  2. If you don't see the new table in mgt studio
  3. select * from INFORMATION_SCHEMA.TABLES
  4. You should see the new table

Not sure why this happened, server might need more memory / cpu..

Upvotes: 0

Tharif
Tharif

Reputation: 13971

Check Refreshing the database in object explorer.

image

Upvotes: 1

Rahul Tripathi
Rahul Tripathi

Reputation: 172628

Simply go your database and write this query:

USE DBName --Change the database name in which you have created your table
GO 
IF (EXISTS (SELECT * 
             FROM INFORMATION_SCHEMA.TABLES 
             WHERE TABLE_SCHEMA = 'TheSchema' 
             AND  TABLE_NAME = 'Faculty'))
BEGIN
print 'table exists'    
END

Check if your table exists in the database. If the table is created then it will be listed here else there might be some problem while creation.

And if the above query shows the table which you are looking for in the database then I would recommend to restart your management studio and check again.

Upvotes: 1

Related Questions