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.

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.