Count all register from all tables.

Question

Count all register from all tables.

rodrigo.rollo

SSC-Addicted

Points: 415
More actions
June 6, 2008 at 2:35 pm

#188726

Hello all,
Anyone know how can I count all registers from all tables of my data base?
Tks all

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

Not sure what you mean by "registers" in this context.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

rodrigo.rollo SSC-Addicted Points: 415 More actions · Answer 2

I just want to COUNT all tables from my database. I can see the most populated tables.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

use [YourDatabase]

go

select count(*) from sys.tables

go

Jack Corbett SSC Guru Points: 184394 More actions · Answer 4

Do you mean a count of the # of rows in each table in a database? Either of these will work although the second would the recommended approach in SQL Server 2005:

Select Object_Name(Id), rows from sys.sysindexes where indid < 2

Select Object_Name(Object_Id), row_count from sys.dm_db_partition_stats

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

rodrigo.rollo SSC-Addicted Points: 415 More actions · Answer 5

I think that I'm not expressing fine.

I need to show more populated tables of my db. I need a kind of select to count all registers of all tables.

Select count(*) from table but i need one select to count all tables

rodrigo.rollo SSC-Addicted Points: 415 More actions · Answer 6

Jack, your select resolve my problem.

Tks a lot to all.