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