IBM Books

Administration Guide


OBJCAT.KEYCOLUSE

Lists all columns that participate in a key (including inherited primary or unique keys where applicable) defined by a unique, primary key or foreign key constraint.

Table 111. OBJCAT.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).

ORIGIN_TABSCHEMA CHAR(8)
Qualified name of the table in the table hierarchy where the key was introduced.
ORIGIN_TABNAME VARCHAR(18)


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

[ DB2 List of Books | Search the DB2 Books ]