Posted on 2014-03-04
I'm wondering why I cannot see a table columns in SQL Server management studio.
Let's say dbo.table1, when I expend the + sign baside the table name, Keys, Constraints, Triggers, Index and Statistics items are listed under table name level.
But there's no + sign for the Columns item, and there are + sign for Keys, Constraints, Triggers, Index and Statistics items. So I can see expended tree of those items except the Column item.
When I execute
select * from dbo.table1,
I can see table titles but no row is selected.
Why I cannot see any column of this table while I can see cloumns of any other column under same schema, like dbo.allothertables?
What would be the reason to cause this?