The HSURDEKY table is used for DB2 table external keys and is populated during the DB2 Catalog Synchronization phase. The following table describes the columns in the HSURDEKY table:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| TBCREATOR | CHARACTER | 128 | 0 | table creator |
| TBNAME | CHARACTER | 128 | 0 | table name |
| IXCREATOR | CHARACTER | 128 | 0 | index creator |
| IXNAME | CHARACTER | 128 | 0 | index name |
| COLSEQ | BINARY | 2 | 0 | index column sequence |
| COLNAME | CHARACTER | 30 | 0 | index column name |
| COLNO | BINARY | 2 | 0 | index column number |