try this ....lots of solutions if you care to search on the web.
https://www.mssqltips.com/sqlservertip/2537/sql-server-row-count-for-all-tables-in-a-database/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day