From 46651ce6fe013220ed397add242004d764fc0153 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:15:05 +0200 Subject: Adding upstream version 14.5. Signed-off-by: Daniel Baumann --- .../html/infoschema-referential-constraints.html | 70 ++++++++++++++++++++++ 1 file changed, 70 insertions(+) create mode 100644 doc/src/sgml/html/infoschema-referential-constraints.html (limited to 'doc/src/sgml/html/infoschema-referential-constraints.html') diff --git a/doc/src/sgml/html/infoschema-referential-constraints.html b/doc/src/sgml/html/infoschema-referential-constraints.html new file mode 100644 index 0000000..5b3d48d --- /dev/null +++ b/doc/src/sgml/html/infoschema-referential-constraints.html @@ -0,0 +1,70 @@ + +37.34. referential_constraints
37.34. referential_constraints
Prev UpChapter 37. The Information SchemaHome Next

37.34. referential_constraints

+ The view referential_constraints contains all + referential (foreign key) constraints in the current database. + Only those constraints are shown for which the current user has + write access to the referencing table (by way of being the + owner or having some privilege other than SELECT). +

Table 37.32. referential_constraints Columns

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


Prev Up Next
37.33. parameters Home 37.35. role_column_grants
\ No newline at end of file -- cgit v1.2.3