Query 12) How to find the space utilized by particular database in teradata ?
To find out how much space a table is using in a database use below query in Teradata:
DATABASENAME as Database
,TABLENAME as Table
,SUM(CURRENTPERM)/(1024*1024*1024) (DECIMAL(15,6)) as Current_Size
WHERE DATABASENAME = ‘YOUR_DATABASE_NAME‘
GROUP BY 1,2;