Administration Guide

SYSCAT.REFERENCES

Contains a row for each defined referential constraint.

Table 102. SYSCAT.REFERENCES Catalog View

Column Name Data Type Nullable Description
CONSTNAME VARCHAR(18)
Name of constraint.
TABSCHEMA VARCHAR(128)
Qualified name of the constraint.
TABNAME VARCHAR(128)
DEFINER VARCHAR(128)
User who created the constraint.
REFKEYNAME VARCHAR(18)
Name of parent key.
REFTABSCHEMA VARCHAR(128)
Name of the parent table.
REFTABNAME VARCHAR(128)
COLCOUNT SMALLINT
Number of columns in the foreign key.
DELETERULE CHAR(1)
Delete rule:

A = NO ACTION
C = CASCADE
N = SET NULL
R = RESTRICT

UPDATERULE CHAR(1)
Update rule:

A = NO ACTION
R = RESTRICT

CREATE_TIME TIMESTAMP
The timestamp when the referential constraint was defined.
FK_COLNAMES VARCHAR (640)
List of foreign key column names. Warning: This column will be removed in the future. Use SYSCAT.KEYCOLUSE for this information.
PK_COLNAMES VARCHAR (640)
List of parent key column names. Warning: This column will be removed in the future. Use SYSCAT.KEYCOLUSE for this information.

Note:

The SYSCAT.REFERENCES view is based on the SYSIBM.SYSRELS table from Version 1.

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

[ DB2 List of Books | Search the DB2 Books ]