Archives of the TeradataForum
Message Posted: Tue, 06 May 2003 @ 14:02:08 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|