ADM_CONSTRAINTS

ADM_CONSTRAINTS displays information about table constraints in 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 both PG_CATALOG and SYS schema.

**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 a constraint-related index (only for the unique constraint and primary key constraint)