Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

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


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
           , (show select * from myviews.someview) as view_descript

Any ideas?



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