CODEWITHSUNDEEP
sqlsql-server
sc1324
sc1324

Reputation: 600

Table not visible but accessible in SQL Server

I am using SQL Server 2016 Management Studio, and I encounter something that I haven't seen before and I probably just need some explanation no technical coding involved.

So I was working on some query and need to find tables and usually I check Object Explorer and directly right click table for the first 1000 records. I was joining my claims table with another table for amounts paid column, and I couldn't locate my second table.

I could use select * to get the columns of the table, but it is not visible in my object explorer. Not sure if I am blocked from viewing, but this is my first time seeing it.

I am showing you where my claims table ends and right after it is the Communication table.

enter image description here

enter image description here

Upvotes: 1

Views: 3444

Answers (1)

Michael Bruesch
Michael Bruesch

Reputation: 660

Just for an official answer (answers were given in OP comments):

The "table" you can't find is actually a View and can be found in the Views subfolder under the Database.

enter image description here

Upvotes: 2

Related Questions