SYSREFCST

The SYSREFCST view contains one row for each foreign key in the SQL schema.

The following table describes the columns in the SYSREFCST view:

Table 1. SYSREFCST view
Column Name	System Column Name	Data Type	Description
CONSTRAINT_SCHEMA	CDBNAME	VARCHAR(128)	Name of the schema containing the constraint.
CONSTRAINT_NAME	RELNAME	VARCHAR(128)	Name of the constraint.
UNIQUE_CONSTRAINT_SCHEMA	UNQDBNAME	VARCHAR(128) Nullable	Name of the SQL schema containing the unique constraint referenced by the referential constraint. Contains the null value if the unique constraint does not exist. This is usually caused by restoring the table without its parent table.
UNIQUE_CONSTRAINT_NAME	UNQNAME	VARCHAR(128) Nullable	Name of the unique constraint referenced by the referential constraint. Contains the null value if the unique constraint does not exist. This is usually caused by restoring the table without its parent table.
MATCH_OPTION	MATCH	VARCHAR(7)	Match option. Will always be NONE.
UPDATE_RULE	UPDATE	VARCHAR(11)	Update Rule. NO ACTION RESTRICT
DELETE_RULE	DELETE	VARCHAR(11)	Delete Rule NO ACTION CASCADE SET NULL SET DEFAULT RESTRICT
COLUMN_COUNT	COLCOUNT	INTEGER	Number of columns in the foreign key.
SYSTEM_CONSTRAINT_SCHEMA	SYS_CDNAME	CHAR(10)	Name of the system schema containing the constraint.
SYSTEM_UNIQUE_CONSTRAINT_SCHEMA	SYS_UDNAME	CHAR(10) Nullable	Name of the system schema containing the constraint. Contains the null value if the unique constraint does not exist. This is usually caused by restoring the table without its parent table.