From 5e45211a64149b3c659b90ff2de6fa982a5a93ed Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:17:33 +0200 Subject: Adding upstream version 15.5. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/infoschema-key-column-usage.html | 65 ++++++++++++++++++++++ 1 file changed, 65 insertions(+) create mode 100644 doc/src/sgml/html/infoschema-key-column-usage.html (limited to 'doc/src/sgml/html/infoschema-key-column-usage.html') diff --git a/doc/src/sgml/html/infoschema-key-column-usage.html b/doc/src/sgml/html/infoschema-key-column-usage.html new file mode 100644 index 0000000..0c4546e --- /dev/null +++ b/doc/src/sgml/html/infoschema-key-column-usage.html @@ -0,0 +1,65 @@ + +37.32. key_column_usage
37.32. key_column_usage
Prev UpChapter 37. The Information SchemaHome Next

37.32. key_column_usage

+ The view key_column_usage identifies all columns + in the current database that are restricted by some unique, primary + key, or foreign key constraint. Check constraints are not included + in this view. Only those columns are shown that the current user + has access to, by way of being the owner or having some privilege. +

Table 37.30. key_column_usage Columns

+ Column Type +

+

+ Description +

+ constraint_catalog sql_identifier +

+

+ Name of the database that contains the constraint (always the current database) +

+ constraint_schema sql_identifier +

+

+ Name of the schema that contains the constraint +

+ constraint_name sql_identifier +

+

+ Name of the constraint +

+ table_catalog sql_identifier +

+

+ Name of the database that contains the table that contains the + column that is restricted by this constraint (always the + current database) +

+ table_schema sql_identifier +

+

+ Name of the schema that contains the table that contains the + column that is restricted by this constraint +

+ table_name sql_identifier +

+

+ Name of the table that contains the column that is restricted + by this constraint +

+ column_name sql_identifier +

+

+ Name of the column that is restricted by this constraint +

+ ordinal_position cardinal_number +

+

+ Ordinal position of the column within the constraint key (count + starts at 1) +

+ position_in_unique_constraint cardinal_number +

+

+ For a foreign-key constraint, ordinal position of the referenced + column within its unique constraint (count starts at 1); + otherwise null +


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