[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 285
  • Last Modified:

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?
0
dwiseman3
Asked:
dwiseman3
2 Solutions
 
Ess KayEntrapenuerCommented:
permissions?

Or wrong server

Or wrong login



How about a screenshot
0
 
Jim HornMicrosoft 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
 
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
QlemoC++ DeveloperCommented:
Maybe it's a synonym, pointing into another DB?
0
 
Jim P.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
 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now