Archives of the TeradataForum
Message Posted: Mon, 18 Jan 2016 @ 21:10:56 GMT
| Subj: | | Re: How to identify aliased columns in a view |
| |
| From: | | Nazy Gholizadeh |
Dave Clark wrote:
| | The problem is that DBC.COLUMNS.COLUMNNAME and COLUMNTYPE is NULL for VIEWS. This is not true for tables (including temporary tables).
As an interim workaround, it is possible to create a temp table to get the information and then delete the temp table. | |
Dave, Would you please expand on that?
What do you mean by create a temp table as a work around?
I still don't know where to get the actual column name instead of the alias name when I do a list column on the view.
Thanks,
Nazy Gholizadeh
Teradata DBA - Enterprise Data Warehouse
The Goodyear Tire & Rubber Company
| 
