Snowsight - Databases: Procedure Details

When you select a procedure in the database object explorer, the procedure details page appears.

In this Topic:

This section provides a brief overview of how to navigate and use the procedure details page.

Interface

Description

Basic function details

Basic details about your function are located at the top of the page.

More menu

The More menu, located in the upper-right corner of the page, lets you do the following:

  • Edit

    Edit the procedure name and comment.

  • Drop

    Drop the procedure.

  • Transfer Ownership

    Transfer ownership of the procedure to another role.

The procedure details page includes the following sections:

  • Details

  • Procedure definition

  • Privileges

The Details section provides additional information about your procedure, including:

  • The data type of the procedure result.

  • Whether your procedure is an aggregate function.

  • Whether your procedure is a secure function.

  • Whether your procedure is a table function.

  • The language used to build the procedure.

The Procedure definition section contains the SQL that was used to initialize the procedure.

Use the Privileges section to view, grant, and revoke privileges on the procedure.