Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Lists any existing user-defined functions in the specified database, including user-defined scalar-valued functions (UDFs), user-defined table-valued functions (TVFs), and stored procedures.
SHOW PROCEDURES
is an alias for this command.
SHOW FUNCTIONS [{FROM | IN} database_name] [LIKE pattern]
The SHOW FUNCTIONS
command can be used to list functions in the current database or in another database. The function list returns the name for each function, whether they are a UDF, TVF, or stored procedure, and who is the function definer. To show user-defined aggregate functions (UDAFs), see SHOW AGGREGATES.
The following example lists each function in the current database.
SHOW FUNCTIONS;
+------------------+-----------------------+----------------+
| Functions_in_db1 | Function Type | Definer |
+------------------+-----------------------+----------------+
| myfunction | User Defined Function | root@localhost |
| myprocedure | Stored Procedure | root@localhost |
+------------------+-----------------------+----------------+
1 row in set (0.00 sec)
Related Topics