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/