Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using SQL Server 2005.My question is;I am looking for a query that listing all rows and sizes of tables in a Database.

share|improve this question
Shouldn't the title be fixed? You mean row counts and not the rows themselves. – bernd_k Feb 12 '11 at 16:05
up vote 0 down vote accepted

A few examples here.

share|improve this answer
The link is great, but answers just consisting of a link cf.… – bernd_k Feb 12 '11 at 16:09

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.