Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Find the number of rows of all tables in a database?
From:   Dempsey, Mike

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023