Can not see a table in management studio but can update it

I can not see the table in the table list in Management Studio but I can select and update data in it. What could be the problem?
dwiseman3Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Jim P.Connect With a Mentor Commented:
How are you logged in? Are you using the SA account with SQL auth or windows authentication.

Is there a folder under the tables view is the a %userid% schema?

Do a
SELECT *
FROM sys.objects
WHERE [Name] LIKE '%subject%'

Open in new window

0
 
Ess KayEntrapenuerCommented:
permissions?

Or wrong server

Or wrong login



How about a screenshot
0
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
<... adding onto the fun ...>
Are you certain?  Is it a table, view, or table valued function?  
Does it have a schema other than dbo, which means it sorts schema first, then object name?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
dwiseman3Author Commented:
Hope you can see that the table does not appear.
If I link to the tables via ODBC I can select the zsubject table but I can not update it.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>Hope you can see that the table does not appear.
Uhh, no.
We don't have access to your SSMS, and esskayb2d asked you for a screen shot that hasn't been provided yet.
Experienced experts here know not to assume things.
0
 
dwiseman3Author Commented:
here is the file. I thought it attached in my last post.
zsubject.docx
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
In your screenshot, scroll up to make sure that the table list is inside the database named 'Sandbox', as that's what is displayed in the database combo box in the toolbar.
0
 
dwiseman3Author Commented:
The table list I showed is under Sandbox.
We have several databases, all historical snapshots of the production database.
Zsubject does not appear in any of them except the original database GwenSandbox.
See the attached screenshot.
zsubject-GS-database.docx
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>Zsubject does not appear in any of them except the original database GwenSandbox.
In your first screen shot the database combo box showed Sandbox, which means the UPDATE query executes against Sandbox.  So, if zsubject doesn't appear in Sandbox, executing the statement would return an error.

Just for kicks and giggles, try these
update sandbox..zsubject
set descript = 'World Language'
where subjectc = 'L'

update GwenSandbox..zsubject
set descript = 'World Language'
where subjectc = 'L'

Open in new window


Also, if the table was added recently, to view it you'll have to go to Tables and do a right-click:Refresh.

I'm not aware of a .Visible property to a table.
0
 
dwiseman3Author Commented:
I executed the update statement against the database where the table does not appear in the list. I can't update Gwensandbox. It is a historical record.
I know how to refresh the list.
0
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Maybe it's a synonym, pointing into another DB?
0
 
dwiseman3Author Commented:
The select from sys.objects identified the object as a view not a table.
I was so sure it was a table because it had been one in our original database.
Someone changed the object type to a view...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.