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 --- doc/src/sgml/html/infoschema-view-table-usage.html | 47 ++++++++++++++++++++++ 1 file changed, 47 insertions(+) create mode 100644 doc/src/sgml/html/infoschema-view-table-usage.html (limited to 'doc/src/sgml/html/infoschema-view-table-usage.html') diff --git a/doc/src/sgml/html/infoschema-view-table-usage.html b/doc/src/sgml/html/infoschema-view-table-usage.html new file mode 100644 index 0000000..46206c7 --- /dev/null +++ b/doc/src/sgml/html/infoschema-view-table-usage.html @@ -0,0 +1,47 @@ + +37.65. view_table_usage
37.65. view_table_usage
Prev UpChapter 37. The Information SchemaHome Next

37.65. view_table_usage

+ The view view_table_usage identifies all tables + that are used in the query expression of a view (the + SELECT statement that defines the view). A + table is only included if that table is owned by a currently + enabled role. +

Note

+ System tables are not included. This should be fixed sometime. +

Table 37.63. view_table_usage Columns

+ Column Type +

+

+ Description +

+ view_catalog sql_identifier +

+

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

+ view_schema sql_identifier +

+

+ Name of the schema that contains the view +

+ view_name sql_identifier +

+

+ Name of the view +

+ table_catalog sql_identifier +

+

+ Name of the database that contains the table that is + used by the view (always the current database) +

+ table_schema sql_identifier +

+

+ Name of the schema that contains the table that is used by the + view +

+ table_name sql_identifier +

+

+ Name of the table that is used by the view +


Prev Up Next
37.64. view_routine_usage Home 37.66. views
\ No newline at end of file -- cgit v1.2.3