This tutorial video will walk you through how to count how many rows there are in every table in a database. You can also sort by schema. It is all done by looking at the sys tables.
Github Script:
https://github.com/ProfessorPitch/ProfessorPitch/blob/master/SQL/Table%20Rowcount.sql
