Skip to main content

DESCRIBE PROCEDURE

Preview

This feature is in Public Preview.

Applies to: check marked yes Databricks Runtime 17.0 and above

Returns the basic metadata information of an existing procedure. The metadata information includes the procedure name and parameters. If the optional EXTENDED option is specified, the basic metadata information is returned along with the extended usage information.

Syntax​

{ DESC | DESCRIBE } PROCEDURE [ EXTENDED ] procedure_name

Parameters​

  • procedure_name

    The name of an existing procedure in the metastore. The procedure name can be optionally qualified with a schema name. If procedure_name is not qualified with a schema, the procedure is resolved in the current schema.

Examples​

SQL
> CREATE PROCEDURE greeting(IN mode STRING COMMENT 'informal or formal')
    LANGUAGE SQL
    SQL SECURITY INVOKER
    AS BEGIN
        SELECT 'Hello!';
        CASE mode WHEN 'informal' THEN SELECT 'Hi!';
                  WHEN 'forma' THEN SELECT 'Pleased to meet you.';
        END CASE;
    END;

> DESCRIBE PROCEDURE greeting;
 Procedure:  main.default.greeting
 Parameters: IN mode STRING

> DESCRIBE PROCEDURE EXTENDED greeting;
Procedure:     main.srielau.greeting
Parameters:    IN mode STRING 'informal or formal'
Deterministic: false
Data Access:   MODIFIES SQL DATA
Security Type: INVOKER
Configs: ...
Owner:         alf@melmak.et
Create Time:   Mon May 12 08:11:17 UTC 2025
"Body:          BEGIN
        SELECT 'Hello!';
        CASE mode WHEN 'informal' THEN SELECT 'Hi!';
                  WHEN 'forma' THEN SELECT 'Pleased to meet you.';
        END CASE;
    END"
Language:      SQL
Last updated on