System Tables - DB2

System Table NameDescriptionColumns
SYSIBM.SYSTABLESTablesNAME, CREATOR
SYSIBM.SYSCOLUMNSTable ColumnsNAME, TBNAME, TBCREATOR, NULLS, LENGTH, SCALE, COLNO, TYPENAME, DEFAULT
SYSIBM.SYSINDEXESIndexesNAME, CREATOR, TBNAME, TBCREATOR, COLNAMES, UNIQUERULE, INDEXTYPE
SYSIBM.SYSINDEXCOLUSEIndex ColumnsINDNAME, COLNAME, COLSEQ, COLORDER
SYSIBM.SYSDATATYPESData TypesNAME, TYPEID