Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 08 Apr 2005 @ 21:00:49 GMT


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


Subj:   Re: Biggest table in DB
 
From:   Vakkalagadda, Sridhar

A simple one would be

     Sel top 1* from (SELECT DatabaseName, tablename,
     CAST((sum(currentperm))/1024/1024/1024 AS DECIMAL(10,2))
     AS Table_Size_In_GB FROM dbc.tablesize GROUP BY 1,2 ) A order by 3 desc;

- Sri



     
  <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