db2 "? describe"
DESCRIBE {[OUTPUT] {select-statement | call-statement} |
{TABLE | INDEXES FOR TABLE} table-name [SHOW DETAIL] }

주: 운영 체제 프롬프트에서는, 명령 앞에 'db2'라는 접두어를 붙이십시오.
      특정 문자에는 이탈 순서(\)가 필요할 수도 있습니다. 예:
      db2 \? change database
      db2 ? change database xxx comment with \"텍스트\"

db2 describe table org   ( show detail )          

Column                         Type      Type
name                           schema    name               Length   Scale Nulls
------------------------------ --------- ------------------ -------- ----- ------
DEPTNUMB                       SYSIBM    SMALLINT                  2     0 No   
DEPTNAME                       SYSIBM    VARCHAR                  14     0 Yes  
MANAGER                        SYSIBM    SMALLINT                  2     0 Yes  
DIVISION                       SYSIBM    VARCHAR                  10     0 Yes  
LOCATION                       SYSIBM    VARCHAR                  13     0 Yes   

db2 describe indexes for table org show detail

Index                           Index              Unique         Number of
schema                          name               rule           columns        Column names
------------------------------- ------------------ -------------- -------------- ------------------------------------------------------------
TINST1                          IORG1              D                           1 +DEPTNUMB