Information on routines is provided in the information schemas, see chapter “Information schemas”.
Information schema |
View |
Information on |
INFORMATION_SCHEMA |
PARAMETERS |
Parameters of routines |
INFORMATION_SCHEMA |
ROUTINES |
Routines |
INFORMATION_SCHEMA |
ROUTINE_PRIVILEGES |
Privileges for routines |
INFORMATION_SCHEMA |
ROUTINE_TABLE_USAGE |
Tables in routines |
INFORMATION_SCHEMA |
ROUTINE_COLUMN_USAGE |
Columns in routines |
INFORMATION_SCHEMA |
ROUTINE_ROUTINE_USAGE |
Routines in other routines |
INFORMATION_SCHEMA |
VIEW_ROUTINE_USAGE |
Routines in views |
SYS_INFO_SCHEMA |
SYS_PARAMETERS |
Parameters of routines |
SYS_INFO_SCHEMA |
SYS_ROUTINES |
Routines |
SYS_INFO_SCHEMA |
SYS_ROUTINE_PRIVILEGES |
Privileges for routines |
SYS_INFO_SCHEMA |
SYS_ROUTINE_USAGE |
Tables and columns in routines |
SYS_INFO_SCHEMA |
SYS_ROUTINE_ERRORS |
Error events in routines |
SYS_INFO_SCHEMA |
SYS_ROUTINE_ROUTINE_USAGE |
Routines in other routines |
SYS_INFO_SCHEMA |
SYS_VIEW_ROUTINE_USAGE |
Routines in views |
Table 27: Routines in the information schemas