SYS_UNIQUE_CONSTRAINTS

Information on primary key and UNIQUE constraints.

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
TABLE_NAME	CHAR (31)	Name of the table to which the integrity constraint belongs
COLUMN_NAME	CHAR (31)	Name of a column in the integrity constraint
ORDINAL_POSITION	SMALLINT	Position of the column in the integrity constraint
CONST_TYPE_ID	CHAR (1)	P PRIMARY KEY constraint U UNIQUE constraint
INDEX_NAME	CHAR (18)	Name of the index for the UNIQUE constraint NULL value for primary key constraints

Table 137: SYS_UNIQUE_CONSTRAINTS view of the SYS_INFO_SCHEMA