You are viewing an older version of this section. View current production version.
SHOW FUNCTIONS
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.
Syntax
SHOW FUNCTIONS [{FROM | IN} database_name] [LIKE pattern]
Remarks
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.
Example
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
