Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Important
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_name
is not provided the procedure name may be qualified with a schema name instead. Ifprocedure_name
is not qualified andschema_name
has 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