a guest May 25th, 2019 70 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select tab.table_schema,
  2.        tab.table_name,
  3.        tinf.tbl_rows as rows
  4. from svv_tables tab
  5. join svv_table_info tinf
  6.           on tab.table_schema = tinf.schema
  7.           and tab.table_name = tinf.table
  8. where tab.table_type = 'BASE TABLE'
  9.       and tab.table_schema not in('pg_catalog','information_schema')
  10.       and tinf.tbl_rows > 1
  11. order by tinf.tbl_rows desc;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand