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	Date and time the object was last altered. See Usage Notes.
COMMENT	TEXT	Comment for this stored procedure.
OWNER_ROLE_TYPE	TEXT	The type of role that owns the object, either `ROLE` or `DATABASE_ROLE`. . If a Snowflake Native App owns the object, the value is `APPLICATION`. . Snowflake returns NULL if you delete the object because a deleted object does not have an owner role.

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.
The LAST_ALTERED column is updated when the following operations are performed on an object:
- DDL operations.
- DML operations (for tables only).
- Background maintenance operations on metadata performed by Snowflake.