Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 08 Apr 2010 @ 14:29:26 GMT


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


Subj:   Re: Finding data types in views
 
From:   John_Wight

You can do a HELP_COLUMNS ..*; and get all the physical attributes of any view. However, this only does it for one view at a time. I created a BTEQ process that would go through a DB (one or more) that contained views and end up putting all the detail view column characteristics into a table for users/developers, etc. to reference. There is no easy way (never has been for TD) to get the column characteristics from the DD/DC with SQL like, say Oracle ! BI tools generally use the HELP COLUMN command to retrieve those and I would think that SQL Assistant does also.


JK Wight



     
  <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: 15 Jun 2023