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