Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 20 May 2011 @ 12:17:56 GMT

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

Subj:   Re: Find the number of rows of all tables in a database?
From:   Mukardamwala Suhel

I think you are right. I had a similar problem long back.

Take out the names of table/views into a flat file. Put a loop and feed one by one table name into query.

Better to use perl or any other script where you can fire multiple queries without disconnecting from database. (i.e. in single session )

Try to avoid business window if you are running on production system.

Thanks and regards,

Suhel Mukardamwala

  <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