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 the constraint-related index (only for the unique constraint and primary key constraint).
status	character varying(8)	Constraint status.
generated	character varying(14)	Not supported. Its value is NULL.
search_condition	text	Not supported. Its value is NULL.
search_condition_vc	character varying(4000)	Not supported. Its value is NULL.
r_owner	character varying(128)	Not supported. Its value is NULL.
r_constraint_name	character varying(128)	Not supported. Its value is NULL.
delete_rule	character varying(9)	Not supported. Its value is NULL.
con_deferrable	character varying(14)	Not supported. Its value is NULL.
deferred	character varying(9)	Not supported. Its value is NULL.
validated	character varying(13)	Not supported. Its value is NULL.
bad	character varying(3)	Not supported. Its value is NULL.
rely	character varying(4)	Not supported. Its value is NULL.
last_change	date	Not supported. Its value is NULL.
invalid	character varying(7)	Not supported. Its value is NULL.
view_related	character varying(14)	Not supported. Its value is NULL.
origin_con_id	character varying(256)	Not supported. Its value is NULL.