ADM_CONSTRAINTS

ADM_CONSTRAINTS displays information about table constraints in database. By default, only users with the SYSADMIN permission can access this system view. Common users can access it only after being authorized. This view exists in both PG_CATALOG and SYS schemas.

**Table 1** ADM_CONSTRAINTS columns
Name	Type	Description
owner	character varying(64)	Constraint creator.
constraint_name	character varying(64)	Constraint name.
constraint_type	text	Constraint type. c: check constraint. f: foreign key constraint. p: primary key constraint. u: unique constraint.
table_name	character varying(64)	Name of a constraint-related table.
index_owner	character varying(64)	Owner of a constraint-related index (only for the unique constraint and primary key constraint).
index_name	character varying(64)	Name of the constraint-related index (only for the unique constraint and primary key constraint).