[DB2] Table Schema

1. Show all index
SELECT * FROM SYSIBM.SYSINDEXES WHERE TBNAME='TABLE NAME'

The column UNIQUERULE:
D = means duplicate allowed     P = means primary index     U = means unique index


2. Show all columns
SELECT * FROM SYSIBM.SYSCOLUMNS WHERE TBNAME='TABLE NAME'