SYS_TABLE_CONSTRAINTS

Information on all integrity constraints on the tables in the database

Column name	Data type	Contents
CONSTRAINT_SCHEMA	CHAR (31)	Name of the schema to which the table with the integrity constraint belongs
CONSTRAINT_NAME	CHAR (31)	Name of the integrity constraint
CONSTRAINT_TYPE	VARCHAR (11)	Type of integrity constraint: FOREIGN KEY UNIQUE PRIMARY KEY CHECK
TABLE_NAME	CHAR (31)	Name of the table to which the integrity constraint belongs

Table 136: SYS_TABLE_CONSTRAINTS view of the SYS_INFO_SCHEMA