Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 21 Nov 2014 @ 15:08:27 GMT


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


Subj:   Re: Macro/Formulae to get DDL's and counts of all
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, November 21, 2014 09:54 -->

As far as DDL, you can put SHOW in front of whatever DML statement, not just "SELECT * FROM view".

Consider using Query Capture Facility and the Visual Explain tool, even if you don't use the diagram view.

All the things you mention (stats, DDL, etc.) are easily viewable from within this tool.



     
  <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: 23 Jun 2019