REFERENTIAL CONSTRAINTS

Go Up to System Views

REFERENTIAL_CONSTRAINTS identifies all referential constraints defined in a database.

REFERENTIAL_CONSTRAINTS

Column name	Datatype	Length	Description
CONSTRAINT_NAME	CHAR	67	Unique name for the constraint; nullable
UNIQUE_CONSTRAINT_NAME	CHAR	67	Name of the UNIQUE or PRIMARY KEY constraint corresponding to the specified referenced column list; nullable
MATCH_OPTION	CHAR	7	Reserved for future use; always set to FULL; nullable
UPDATE_RULE	CHAR	11	Reserved for future use; always set to RESTRICT; nullable
DELETE_RULE	CHAR	11	Reserved for future use; always set to RESTRICT; nullable