How much space are your tables using? in Teradata

You can measure the space used by the tables in bytes across databases.

Syntax:
SELECT tablename,sum(currentperm)/1024*1024 Bytes_usage
FROM dbc.allspace
WHERE databasename='your_database_name'
GROUP BY 1
ORDER BY 2 DESC;


Example:
SELECT tablename,SUM(currentperm)/1024*1024 Bytes_usage
FROM dbc.allspace
WHERE databasename='ForgetCode'
GROUP BY 1
ORDER BY 2 DESC;


Output:
TableNameBytes_usage
All5120.00
student3072.00
T2048.00