Monday, March 12, 2012

Row Count on all Tables in Database?

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<-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<-
>|||Perfect, thank you!
"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...
>

No comments:

Post a Comment