PROCEDURES View¶
This Information Schema view displays a row for each stored procedure defined in the specified (or current) database.
For more information about stored procedures, see Stored Procedures Overview.
Columns¶
Column Name |
Data Type |
Description |
|---|---|---|
PROCEDURE_CATALOG |
TEXT |
Database which the stored procedure belongs to |
PROCEDURE_SCHEMA |
TEXT |
Schema which the stored procedure belongs to |
PROCEDURE_NAME |
TEXT |
Name of the stored procedure |
PROCEDURE_OWNER |
TEXT |
Name of the role that owns the stored procedure |
ARGUMENT_SIGNATURE |
TEXT |
Type signature of the stored procedure’s arguments |
DATA_TYPE |
TEXT |
Return value data type |
CHARACTER_MAXIMUM_LENGTH |
NUMBER |
Maximum length in characters of string return value |
CHARACTER_OCTET_LENGTH |
NUMBER |
Maximum length in bytes of string return value |
NUMERIC_PRECISION |
NUMBER |
Numeric precision of numeric return value |
NUMERIC_PRECISION_RADIX |
NUMBER |
Radix of precision of numeric return value |
NUMERIC_SCALE |
NUMBER |
Scale of numeric return value |
PROCEDURE_LANGUAGE |
TEXT |
Language of the stored procedure |
PROCEDURE_DEFINITION |
TEXT |
Stored procedure definition |
CREATED |
TIMESTAMP_LTZ |
Creation time of the stored procedure |
LAST_ALTERED |
TIMESTAMP_LTZ |
Last altered time of the stored procedure |
COMMENT |
TEXT |
Comment for this stored procedure |
Usage Notes¶
The view only displays objects for which the current role for the session has been granted access privileges. The view does not honor the MANAGE GRANTS privilege and consequently may show less information compared to a SHOW command when both are executed by a user who holds the MANAGE GRANTS privilege.