ADM_CONSTRAINTS

ADM_CONSTRAINTS displays information about table constraints in the database. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in the 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)