Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Tue, 07 May 2002 @ 18:25:26 GMT


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


Subj:   Re: SQL to get table name with row counts?
 
From:   John Street

As most people have mentioned you can generate SQL statements from the DBC dictionary to get the information. For very large systems there is the issue that the count(*)'s will take quite a long while.

If you collect statistics on the tables then a quicker method to do this would be to run help statistics dbname.tablename (again you can generate this via SQL) it also gives you the date the stats were collected.

Another easy option if you only want a small set of tables (or in one database) is to use WinDDI where if you highlight with the cursor the tables you want, right click and then you ca run a row count or statistics report for all the highlighted tables


Cheers

John Street
Senior Principal Consultant,
Relationship Technology Solutions for Financial Services,
NCR Limited



     
  <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: 28 Jun 2020