Previous Topic: SYSTEM.COLUMNNext Topic: SYSTEM.CONSTRAINT

SYSTEM Tables and SYSCA Views › SYSTEM.CONSTKEY

SYSTEM.CONSTKEY

Description

A row of SYSTEM.CONSTKEY represents the foreign key in a referential constraint defined with a CREATE CONSTRAINT statement.

View SYSCA.CONSTKEY is defined on SYSTEM.CONSTKEY.

Note: For more information, see SYSCA Objects.

Column name

Column description

Data type

Null specifi- cation

SCHEMA

Schema-name qualifier of the constraint.

CHAR(18)

NOT NULL

NAME

Constraint name.

CHAR(18)

NOT NULL

SEQUENCE

Key column sequence number.

SMALLINT

NOT NULL

REFNUMBER

Column number of the key column in the referenced table.

SMALLINT

NOT NULL

REFCOLUMN

Column name of the key column in the referenced table.

CHAR(32)

NOT NULL

NUMBER

Number of the key column in the referencing table.

SMALLINT

NOT NULL

COLUMN

Column name of the key column in the referencing table.

CHAR(32)

NOT NULL

FILLER

Reserved for future use.

BINARY(38)

NOT NULL