Archives of the TeradataForum

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

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

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>>