Informationen über Routinen werden in den Informationsschemata bereitgestellt, siehe Kapitel „Informationsschemata".
Information Schema | View | Information über |
INFORMATION_SCHEMA | PARAMETERS | Parameter von Routinen |
INFORMATION_SCHEMA | ROUTINES | Routinen |
INFORMATION_SCHEMA | ROUTINE_PRIVILEGES | Privilegien für Routinen |
INFORMATION_SCHEMA | ROUTINE_TABLE_USAGE | Tabellen in Routinen |
INFORMATION_SCHEMA | ROUTINE_COLUMN_USAGE | Spalten in Routinen |
INFORMATION_SCHEMA | ROUTINE_ROUTINE_USAGE | Routinen in anderen Routinen |
INFORMATION_SCHEMA | VIEW_ROUTINE_USAGE | Routinen in Views |
SYS_INFO_SCHEMA | SYS_PARAMETERS | Parameter von Routinen |
SYS_INFO_SCHEMA | SYS_ROUTINES | Routinen |
SYS_INFO_SCHEMA | SYS_ROUTINE_PRIVILEGES | Privilegien für Routinen |
SYS_INFO_SCHEMA | SYS_ROUTINE_USAGE | Tabellen und Spalten in Routinen |
SYS_INFO_SCHEMA | SYS_ROUTINE_ERRORS | Fehler-Ereignisse in Routinen |
SYS_INFO_SCHEMA | SYS_ROUTINE_ROUTINE_USAGE | Routinen in anderen Routinen |
SYS_INFO_SCHEMA | SYS_VIEW_ROUTINE_USAGE | Routinen in Views |
Tabelle 27: Routinen in den Informationsschemata