(DB2,列出該Table所有的index) describe indexes FOR table

db2 => describe indexes FOR table MyTableName

索引                           索引               唯一         號碼      索引                       索引
綱目                           名稱               規則         直欄      類型              分割
------------------------------- ------------------- -------------- -------------- --------------------------- --------------
MyDBsCHEMA                        IDX_NO                   D                           1 RELATIONAL DATA                                                                 -
SYSIBM                          SQL120118172349760  P                           4 RELATIONAL DATA                                                                 -

    已選取 2 個記錄。