DB2 Scripts - Table Count By Schema

스키마별 테이블 건수 조회 스크립트

SELECT TABLE_SCHEMA
                 , COUNT(*) AS TOTAL_COUNT
                , COUNT(CASE WHEN RIGHT(TABLE_NAME, 6) BETWEEN '000000' AND '999999' THEN 1 -- 숫자6자리로 끝나는 테이블명은 백업용
WHEN RIGHT(TABLE_NAME, 7) = '_BACKUP' THEN 1
WHEN RIGHT(TABLE_NAME,4) = '_TMP' THEN 1
WHEN RIGHT(TABLE_NAME,5) IN ('_TEST','_TEMP') THEN 1) AS UNUSED_GUESS
FROM SYSIBM.TABLES 
GROUP BY ROLLUP(TABLE_SCHEMA)
ORDER BY 2;