Archives of the TeradataForum
Message Posted: Fri, 09 Dec 2011 @ 15:27:32 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|