Archives of the TeradataForum

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

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

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>>