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