Archives of the TeradataForum

Message Posted: Tue, 06 May 2003 @ 14:02:08 GMT

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

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.

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