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