Listing all tables in a database and their row counts and sizes

Geschrieben von Database Magician am Dienstag, 12. Juni 2018

'To get the number of rows in a single table we can use the COUNT(*) or COUNT_BIG(*) functions, e.g.

SELECT COUNT(*) FROM Sales.Customer

This is quite straightforward for a single table, but quickly gets tedious if there are a lot of tables. Here are a few ways of listing all the tables that exist in a database together with the number of rows they contain. '...

https://www.sqlmatters.com/Articles/Listing%20all%20tables%20in%20a%20database%20and%20their%20row%20counts%20and%20sizes.aspx