Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 09 Dec 2011 @ 15:27:32 GMT


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


Subj:   Capture output from "show select *" into a table
 
From:   DUELL, BOB

Hi,

As a quick way to examine the DDL of a view, I often use "show select * from viewname" in SQL Assistant. The result returns a nice display of the DDL for all tables used in the view, plus the view definition itself.

Is there any way to "capture" this output into a table? I'm thinking of something like this:

     insert into mydb.tableinfo (view_name, view_descript)
     select  'myviews.someview' as
     view_name
           , (show select * from myviews.someview) as view_descript

Any ideas?


Thanks!

Bob



     
  <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