Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 08 Apr 2005 @ 14:34:58 GMT

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

Subj:   Re: Biggest table in DB
From:   Ferry, Craig

You can run this query. Obviously it is going to return all tables, so you may want to run in SQL Assistant to cancel after x rows, or set a return limit.

     SELECT DatabaseName,
     CAST((sum(currentperm))/1024/1024/1024 AS DECIMAL(10,2)) AS
     FROM dbc.tablesize
     GROUP BY 1,2
     ORDER BY 3 desc



Craig Ferry
Sr Database Administrator
WESCO Distribution, Inc.

  <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