Thanks for the question, Tirumala.
Asked: November 19, 2020 - 8:05 pm UTC
Last updated: November 24, 2020 - 1:45 am UTC
Version: 11.2
Viewed 1000+ times
You Asked
I need sizes of all columns of a table and the same details of all user tables in db.
-- Query to find # of rows and sizes of All data in Table1
select count(1),
sum(length(column1)),
sum(length(column2)),
sum(length(column3)),
sum(length(column4)),
sum(length(column5))
from TABLE1;
Should I construct similar query for all tables and get the info OR is there a way to do automatically pull all tables sizes ?
and Connor said...
Is this answer out of date? If it is, please let us know via a Comment