Advertisement
Guest User

Untitled

a guest
May 25th, 2019
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement