Archives of the TeradataForum

Message Posted: Fri, 18 Oct 2002 @ 10:45:02 GMT

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

Hope this helps.

Claybourne Barrineau

     Select    Databasename
     ,    Tablename
     ,    Sum(CurrentPerm) / (1024**2) -- To see space in mgs
     From dbc.tablesize
     Where     databasename  =  '?'
     and  tablename =    '?'
     Group By  1,2

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