How to Rank Tables by Row Count in Descending Order

How to Rank Tables by Row Count in Descending Order

I am trying to understand the consume of lines that grow up so fast in the last week.
Is there any way to create a pivot table or query to get 
TABLE NAME                   LINES 
in descending order?