HSURDEKY

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