Archives of the TeradataForum

Message Posted: Fri, 20 May 2011 @ 13:22:52 GMT

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

You can use an Import command in SQL Assistant to do the same thing.

Extract the list of table names to a flat file then run the following query with Import switched on:

     Select count(*) from ?

Point to the flat file containing the list of table names when asked for the Import file name.

The results will be written to an output file. (same name as Import file but with '.log' suffix)

Mike Dempsey

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