CLASS_INSTANCE_PROCEDURES View¶
This Information Schema view displays a row for each procedure in a class instance.
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
PROCEDURE_NAME |
TEXT |
Name of the stored procedure. |
PROCEDURE_INSTANCE_NAME |
TEXT |
Name of the class instance to which the procedure belongs. |
PROCEDURE_INSTANCE_SCHEMA |
TEXT |
Name of the schema to which the class instance belongs. |
PROCEDURE_INSTANCE_DATABASE |
TEXT |
Name of the database to which the class instance belongs. |
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 |
TEXT |
Scale of numeric return value. |
PROCEDURE_LANGUAGE |
TEXT |
Language of the stored procedure. |
PROCEDURE_DEFINITION |
TEXT |
Stored procedure definition. |
CREATED |
TIMESTAMP_LTZ |
Date and time the stored procedure was created. |
LAST_ALTERED |
TIMESTAMP_LTZ |
Date and time the object was last altered. See Usage Notes. |
COMMENT |
TEXT |
Comment for the stored procedure. |
Usage Notes¶
The view only displays objects for which the current role for the session has been granted an instance role with access privileges.
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.
Examples¶
Retrieve the procedures for instances in the mydatabase
database:
SELECT procedure_name,
procedure_instance_name,
argument_signature,
data_type AS return_value_data_type
FROM mydatabase.INFORMATION_SCHEMA.CLASS_INSTANCE_PROCEDURES;