How to calculate the size of a table in teradata?

This forum is for Database developer ( PostgreSQL, MySQL, SQL Server, Oracle etc...) and database Administrator
ramverma
Posts: 392
Joined: Sat Aug 23, 2014 5:34 pm
Contact:

How to calculate the size of a table in teradata?

Postby ramverma » Wed Nov 25, 2015 7:11 pm

How to calculate the size of a table in teradata?


Guest

Re: How to calculate the size of a table in teradata?

Postby Guest » Wed Nov 25, 2015 8:33 pm

hi You can use below query to get the size of the tables on the Teradata.

select
tablename,
databasename,
sum (currentperm)/1024 as SIZE_IN_KB
from dbc.allspace
where tablename <> 'All'
and databasename = 'YOUR_DATABASE_NAME'


Return to “PostgreSQL, MySQL, SQL Server, SQL,PL/SQL, TeraData Developer and DataBase Administration”

Who is online

Users browsing this forum: No registered users and 1 guest