Updated on 2025-07-22 GMT+08:00

ADM_CONS_COLUMNS

ADM_CONS_COLUMNS displays information about constraint columns in database tables. By default, only users with the SYSADMIN permission can access this system view. Common users can access it only after being authorized. This view exists in both PG_CATALOG and SYS schemas.

Table 1 ADM_CONS_COLUMNS columns

Name

Type

Description

owner

character varying(64)

Constraint creator.

column_name

character varying(64)

Name of a constraint-related column.

constraint_name

character varying(64)

Constraint name.

position

smallint

Position of a column in a table.

table_name

character varying(64)

Name of a constraint-related table.