Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 not in('pg_catalog','information_schema')
- and tinf.tbl_rows > 1
- order by tinf.tbl_rows desc;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement