IBM Books

Administration Guide


SYSCAT.KEYCOLUSE

Lists all columns that participate in a key defined by a unique, primary key, or foreign key constraint.

Table 75. SYSCAT.KEYCOLUSE Catalog View
Column Name

Data Type

Nullable

Description

CONSTNAME

VARCHAR(18)



Name of the constraint (unique within a table).

TABSCHEMA CHAR(8)
Qualified name of the table containing the column.
TABNAME VARCHAR(18)
COLNAME

VARCHAR(18)



Name of the column.

COLSEQ

SMALLINT



Numeric position of the column in the
key (initial position=1).


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]