SYS_REFERENTIAL_CONSTRAINTS

Information on referential constraints. The referencing and referenced columns are listed.

Column name	Data type	Contents
CONSTRAINT_SCHEMA	CHAR (31)	Name of the schema to which the table with the referential constraint belongs
CONSTRAINT_NAME	CHAR (31)	Name of the referential constraint
TABLE_NAME	CHAR (31)	Name of the table to which the referential constraint belongs
COLUMN_NAME	CHAR (31)	Name of a referencing column
UNIQUE_CONSTRAINT_SCHEMA	CHAR (31)	Name of the schema of the referenced table
UNIQUE_CONSTRAINT_NAME	CHAR (31)	Name of the UNIQUE or primary key constraint of the referenced table
UNIQUE_CONSTRAINT_TABLE	CHAR (31)	Name of the referenced table
UNIQUE_CONSTRAINT_COLUMN	CHAR (31)	Name of a referenced column
ORDINAL_POSITION	SMALLINT	Position of the column in the referential constraint

Table 123: SYS_REFERENTIAL_CONSTRAINTS view of the SYS_INFO_SCHEMA