From 293913568e6a7a86fd1479e1cff8e2ecb58d6568 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 15:44:03 +0200 Subject: Adding upstream version 16.2. Signed-off-by: Daniel Baumann --- .../html/infoschema-routine-sequence-usage.html | 59 ++++++++++++++++++++++ 1 file changed, 59 insertions(+) create mode 100644 doc/src/sgml/html/infoschema-routine-sequence-usage.html (limited to 'doc/src/sgml/html/infoschema-routine-sequence-usage.html') diff --git a/doc/src/sgml/html/infoschema-routine-sequence-usage.html b/doc/src/sgml/html/infoschema-routine-sequence-usage.html new file mode 100644 index 0000000..40a6170 --- /dev/null +++ b/doc/src/sgml/html/infoschema-routine-sequence-usage.html @@ -0,0 +1,59 @@ + +37.43. routine_sequence_usage
37.43. routine_sequence_usage
Prev UpChapter 37. The Information SchemaHome Next

37.43. routine_sequence_usage #

+ The view routine_sequence_usage identifies all sequences + that are used by a function or procedure, either in the SQL body or in + parameter default expressions. (This only works for unquoted SQL bodies, + not quoted bodies or functions in other languages.) A sequence is only + included if that sequence is owned by a currently enabled role. +

Table 37.41. routine_sequence_usage Columns

+ Column Type +

+

+ Description +

+ specific_catalog sql_identifier +

+

+ Name of the database containing the function (always the current database) +

+ specific_schema sql_identifier +

+

+ Name of the schema containing the function +

+ specific_name sql_identifier +

+

+ The “specific name” of the function. See Section 37.45 for more information. +

+ routine_catalog sql_identifier +

+

+ Name of the database containing the function (always the current database) +

+ routine_schema sql_identifier +

+

+ Name of the schema containing the function +

+ routine_name sql_identifier +

+

+ Name of the function (might be duplicated in case of overloading) +

+ schema_catalog sql_identifier +

+

+ Name of the database that contains the sequence that is used by the + function (always the current database) +

+ sequence_schema sql_identifier +

+

+ Name of the schema that contains the sequence that is used by the function +

+ sequence_name sql_identifier +

+

+ Name of the sequence that is used by the function +


Prev Up Next
37.42. routine_routine_usage Home 37.44. routine_table_usage
\ No newline at end of file -- cgit v1.2.3