Knowledgebase
Does Visual Expert show table aliases?
Posted by Liz Robertson on 09 October 2014 10:32 AM

When listing the tables used by your application, Visual Expert will not be display alliases in most cases. They will be displayed however when the table alias represents a subquery.

For example:

SELECT t1.empname, t1.deptname 

FROM (select * from employee as emp, department as dept) as t1;

 

In this case, emp and dept would not be listed, but t1 would be.

(0 vote(s))
Helpful
Not helpful

Comments (0)
Help Desk by Novalys