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
|
