CLASS_INSTANCE_PROCEDURES view

This Information Schema view displays a row for each procedure in a class instance.

See also:

CLASS_INSTANCES view, CLASS_INSTANCE_FUNCTIONS view, SHOW PROCEDURES

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 by a DML, DDL, or background metadata operation. 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). This column is updated even when no rows are affected by the DML statement.

    • 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;
Copy