By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,767 Members | 1,302 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,767 IT Pros & Developers. It's quick & easy.

how to report the size of each table in a database?

P: n/a
Hey guys,

Does anyone know a way (in Enterprise Manager or thru a SQL statement)
to get the number of rows and the size of each table in a database?
Thks,

Jul 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Select so.name
, Sum(si.rowcnt) As 'Row Count'
, Sum(si.used) * 8 As 'Size in KB'
From sysindexes si

Join sysobjects so On si.id = so.id
Where so.type = 'U' -- user tables
And si.indid in (0, 1, 255)
Group By so.name

Jul 23 '05 #2

P: n/a

<si**********@yahoo.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...
Hey guys,

Does anyone know a way (in Enterprise Manager or thru a SQL statement)
to get the number of rows and the size of each table in a database?
Thks,


http://groups.google.ch/groups?hl=en...ews.bluewin.ch

Simon
Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.