Archives of the TeradataForum

Message Posted: Wed, 24 Oct 2001 @ 11:53:45 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		How does it Do it??

From:		Tony Howe

If I have a query:

   "SELECT EMPID, PRODUCT, CLASS FROM VMDB.V_EMPLOYEE"  ===> vmdb.v_employee is a view

I run an EXPLAIN on it and the explain output will show me the underlying column name from the underlying table that's used in the view. In other words, the above view accesses table CPDWHA.EMPLOYEE which is what comes out on the explain instead of VMDB.V_EMPLOYEE along with column names EMP_ID for EMPID and PROD_CODE for PRODUCT and CLASS_CODE for CLASS. How does the explain tie these view column names back to the real table column names???? I would like to produce a cross reference listing that shows this very thing.

Hope I was able to get my question across.

Thanks, Tony.