This query returns list of tables in a database with their number of rows.

list_tables.sql

select tab.table_schema,
       tab.table_name,
       tinf.tbl_rows as rows
from svv_tables tab
join svv_table_info tinf
          on tab.table_schema = tinf.schema
          and tab.table_name = tinf.table
where tab.table_type = 'BASE TABLE'
      and tab.table_schema  in('src_canvas')
      and tinf.tbl_rows > 1
order by tinf.tbl_rows desc;