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...
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment