Row Count on all Tables in Database?

microsoft.public.sqlserver.programming

3 Nov 2005 5:28 PM

Scott Townsend

I'm looking for a way to get a Row count on all of the tables in a Database.

Is there a slick way of doing a
SELECT COUNT(*)
FROM (All Tables)

Thanks,
Scott<-

3 Nov 2005 5:37 PM

Aaron Bertrand [SQL Server MVP]

http://www.aspfaq.com/2428

Show quote

"Scott Townsend" <scott-i@.-N0-SPAMplease.enm.com> wrote in message
news:%23UlX2vJ4FHA.3588@TK2MSFTNGP15.phx.gbl...
> I'm looking for a way to get a Row count on all of the tables in a
> Database.
>
> Is there a slick way of doing a
> SELECT COUNT(*)
> FROM (All Tables)
>
> Thanks,
> Scott<-
>

3 Nov 2005 6:38 PM

Scott Townsend

Perfect, thank you!
Show quote

"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:ur6EN0J4FHA.1396@TK2MSFTNGP12.phx.gbl...
> http://www.aspfaq.com/2428
>
>
>
> "Scott Townsend" <scott-i@.-N0-SPAMplease.enm.com> wrote in message
> news:%23UlX2vJ4FHA.3588@TK2MSFTNGP15.phx.gbl...
>> I'm looking for a way to get a Row count on all of the tables in a
>> Database.
>>
>> Is there a slick way of doing a
>> SELECT COUNT(*)
>> FROM (All Tables)
>>
>> Thanks,
>> Scott<-
>>
>
>