dbsee_tablemultiset.sql

e/*********************************************************************/
/* Author      : VLDB                                                */
/* Date        : 07/02/2017                                          */
/* Version     : 1                                                   */
/* Description : Generate report on multiset tables                  */
/*********************************************************************/
select t1.databasename as database_name
      ,t1.tablename    as table_name
      ,case when t1.requesttext like '%multiset%' then 'multiset'
            else 'set'
       end as table_type
      ,t2.total_perm as total_perm
from   dbc.tables t1
inner join 
      (select databasename
                 ,tablename
                 ,sum(currentperm) as total_perm
       from   dbc.tablesizev
       group by 1,2) t2
on     t1.databasename = t2.databasename
and    t1.tablename    = t2.tablename
where  tablekind in ('T','O')
;