SHOW PROCEDURES
This feature is in Public Preview.
Applies to: 
Databricks Runtime 17.0 and above
Returns the list of procedures after applying an optional regex pattern.
You can use SHOW PROCEDURES in conjunction with describe procedure to quickly find a function and learn how to use it.
The LIKE clause is optional, and ensures compatibility with other systems.
Syntax
SHOW PROCEDURES [ { FROM | IN } schema_name ]
[ [ LIKE ] { procedure_name | regex_pattern } ]
Parameters
-
Specifies the schema in which procedures are to be listed.
-
A name of an existing procedure in the system. If
schema_nameis not provided the procedure name may be qualified with a schema name instead. Ifprocedure_nameis not qualified andschema_namehas not been specified the procedure is resolved from the current schema. -
regex_pattern
A regular expression pattern that is used to filter the results of the statement.
- Except for
*and|character, the pattern works like a regular expression. *alone matches 0 or more characters and|is used to separate multiple different regular expressions, any of which can match.- The leading and trailing blanks are trimmed in the input pattern before processing. The pattern match is case-insensitive.
- Except for
Returns
A result set with the following columns:
catalog STRING NOT NULL: The catalog name of the procedure.namespace ARRAY[STRING] NOT NULL: The namespace of the procedure.schema STRING NOT NULL: The schema name of the procedure.procedure_name STRING NOT NULL: The name of the procedure.
In Databricks, schema and namespace hold the same information.
Examples
> SHOW PROCEDURES;
main [default] default greeting
> SHOW PROCEDURES LIKE 'g*';
main [default] default greeting