Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 08 Apr 2010 @ 13:51:48 GMT


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


Subj:   Finding data types in views
 
From:   Gronholm, Christer

Hi,

I have over a hundred views and I would need to have the data types of all fields and for all the views. I am using Teradata Assistant 13.0 and when I look at the columns there are the name of the field and it's data type.

However I haven't found a way to get this information through a query to avoid doing a manual job. I activated QueryLog and when I look at the query generated by TD opening the Columns the query only includes the column name.

For tables getting this information there is no problem but when it comes to views in every table in DBC the data types are NULL.

So how does Assistant get the information about the data type also?

Any help appreciated.


Thanks

Christer Gronholm
Solution Architect
Teradata Chile & Peru



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016