SHOW FUNCTION STATUS

List stored functions and their characteristics. View metadata like the database, name, type, and creator of stored functions.

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

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}