SHOW FUNCTION STATUS [LIKE 'pattern' | WHERE expr]
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.
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
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/show-function-status/