Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 06 May 2003 @ 14:02:08 GMT


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


Subj:   Re: List of objects used by views
 
From:   Dempsey, Mike

Issue the command

'SHOW SELECT * FROM '

This will return the create text for all views and tables referenced by the view.

If you want to do this for many views you might want to use Import mode in Queryman (Teradata SQL Assistant) and use the Query 'SHOW SELECT * FROM?'. When it asks for the Import file simply point it to a text file that contains all the view names - one per line. (Qualified by database name if necessary)

It will write out an export file that contains the View/Table definitions for each 'input' view, with a header of the View Name (from the import file) before each set of outputs.



     
  <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