SQL Reference

SYSCAT.REFERENCES

Contains a row for each defined referential constraint.

Table 82. 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.