Solved

Table Name in SQL Tabular

Posted on 2014-09-03
3
123 Views
Last Modified: 2014-09-07
Any idea how to find the actual table used in SQL Tabular ? I have the name in table property and I can' find the actual table using the value provided. Guessing that the name is not the actual table name. Any idea ?

Tks
Table-Name.png
0
Comment
Question by:AXISHK
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 25

Expert Comment

by:chaau
ID: 40302674
You can also check the views. You can select from a view the same way you are selecting from a table.
0
 

Author Comment

by:AXISHK
ID: 40302712
Tks. Where can I add view to a SQL Tabular in SQL Server Data Tools ? Tks
0
 
LVL 25

Accepted Solution

by:
chaau earned 500 total points
ID: 40302716
I think they should be accessible the same way as the tables. BTW, I just realised, is it possible that you are connected to a wrong database?
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question