SELECT  A.CREATOR       "유저"           ,  
        A.NAME          "테이블명"       ,  
        A.REMARKS       "테이블명(한글)" ,  
        B.COLNO         "칼럼번호"       ,  
        B.NAME          "칼럼"           ,  
        B.REMARKS       "칼럼(한글)"     ,  
        B.COLTYPE       "칼럼속성"       ,  
        B.LENGTH        "길이"              
  FROM  SYSIBM.SYSTABLES  A ,                
        SYSIBM.SYSCOLUMNS B                  
WHERE  A.NAME =  B.TBNAME                  
   AND  A.CREATOR = B.TBCREATOR              
    AND  TBNAME =  'DCRT_NICE_EARL_ALRM_BASE'
   ORDER                                    
      BY  4                                  
  WITH  UR;    

설명]
TBNAME 에 찾고자하는 테이블 이름을 대입해주면 됨