Updated on 2024-05-07 GMT+08:00

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).

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

timestamp(0) without time zone

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.