Archives of the TeradataForum

Message Posted: Mon, 18 Jan 2016 @ 19:31:44 GMT

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

Nazy-

This is targeted as a TD16.0 feature: "Queryable View Column Info" which will provide a Table Operator to return the metadata.

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.clark

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