32.23. `referential_constraints`

The view referential_constraints contains all referential (foreign key) constraints in the current database that belong to a table owned by a currently enabled role.

Table 32-21. referential_constraints Columns

Name	Data Type	Description
`constraint_catalog`	`sql_identifier`	Name of the database containing the constraint (always the current database)
`constraint_schema`	`sql_identifier`	Name of the schema containing the constraint
`constraint_name`	`sql_identifier`	Name of the constraint
`unique_constraint_catalog`	`sql_identifier`	Name of the database that contains the unique or primary key constraint that the foreign key constraint references (always the current database)
`unique_constraint_schema`	`sql_identifier`	Name of the schema that contains the unique or primary key constraint that the foreign key constraint references
`unique_constraint_name`	`sql_identifier`	Name of the unique or primary key constraint that the foreign key constraint references
`match_option`	`character_data`	Match option of the foreign key constraint: `FULL`, `PARTIAL`, or `NONE`.
`update_rule`	`character_data`	Update rule of the foreign key constraint: `CASCADE`, `SET NULL`, `SET DEFAULT`, `RESTRICT`, or `NO ACTION`.
`delete_rule`	`character_data`	Delete rule of the foreign key constraint: `CASCADE`, `SET NULL`, `SET DEFAULT`, `RESTRICT`, or `NO ACTION`.