[ DB2 ] 스키마 내 테이블과 칼럼 정보 조회

SELECT 
    TABLE_NAME, 
    COLUMN_NAME, 
    ORDINAL_POSITION,
    DATA_TYPE,
    LENGTH,
    NUMERIC_SCALE,
    IS_NULLABLE,
    COLUMN_DEFAULT,
    COLUMN_HEADING,
    COLUMN_TEXT AS COMMENT
FROM QSYS2.SYSCOLUMNS
WHERE TABLE_SCHEMA = '스키마명'
ORDER BY TABLE_NAME, ORDINAL_POSITION;