Archives of the TeradataForum
Message Posted: Wed, 02 Aug 2006 @ 10:54:41 GMT
<-- Anonymously Posted: Tuesday, August 01, 2006 21:52 -->
I am trying to do a report on all our views in the warehouse. I want to include the column name along with the data type. Does anyone know how I can get the data type information, since data type fields in DBC.COLUMNS (and tvfields) is null for VIEWS?
I am guessing that it can be done somehow, since you can see data types for columns in views in SQL Assistant.
Any thoughts? Thanks in advance!!!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|