Syntax
------ 
SHOW FUNCTION STATUS
 [LIKE 'pattern' | WHERE expr]
 
Description
----------- 
This statement is similar to 
SHOW PROCEDURE STATUS but for
stored functions.
 
The LIKE clause, if present on its own, indicates which
function names to match. 
 
The WHERE and LIKE clauses can be given to select rows using
more general conditions, as discussed in Extended SHOW.
 
The information_schema.ROUTINES table contains more detailed
information.
 
Examples
-------- 
Showing all stored functions:
 
SHOW FUNCTION STATUS\G
*************************** 1. row
***************************
 Db: test
 Name: VatCents
 Type: FUNCTION
 Definer: root@localhost
 Modified: 2013-06-01 12:40:31
 Created: 2013-06-01 12:40:31
 Security_type: DEFINER
 Comment: 
character_set_client: utf8
collation_connection: utf8_general_ci
 Database Collation: latin1_swedish_ci
 
Stored functions whose name starts with 'V': 
 
SHOW FUNCTION STATUS LIKE 'V%' \G
*************************** 1. row
***************************
 Db: test
 Name: VatCents
 Type: FUNCTION
 Definer: root@localhost
 Modified: 2013-06-01 12:40:31
 Created: 2013-06-01 12:40:31
 Security_type: DEFINER
 Comment: 
character_set_client: utf8
collation_connection: utf8_general_ci
 Database Collation: latin1_swedish_ci
 
Stored functions with a security type of 'DEFINER':
 
SHOW FUNCTION STATUS WHERE Security_type LIKE 'DEFINER'
\G
*************************** 1. row
***************************
 Db: test
 Name: VatCents
 Type: FUNCTION
 Definer: root@localhost
 Modified: 2013-06-01 12:40:31
 Created: 2013-06-01 12:40:31
 Security_type: DEFINER
 Comment: 
character_set_client: utf8
collation_connection: utf8_general_ci
 Database Collation: latin1_swedish_ci
 

 
 
 
 
 
 
 

URL: https://mariadb.com/kb/en/show-function-status/