Archives of the TeradataForum

Message Posted: Mon, 27 Feb 2006 @ 17:35:30 GMT

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

Use SQL Assistant to export a list of the objects to a file.

Select 2 columns:

Column 1 is the object type (Use a Case stmt to convert to full type name. eg. T >> Table, V >> View )

Column 2 is the object name

Then use Import to execute the following command:

     Show ? ?

and point it to the export file when asked for the Import file. (Make sure you set the option to omit the first row, unless you cleared the option that writes column headers to the export file.)

Mike Dempsey
Teradata Client Tools

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