Get list of Procedures and Functions MySQL

Procedures:

Get the list of all Procedures in MySQL.

SHOW PROCEDURE STATUS;

Get the list of all Procedures of a specific Database Schema in MySQL.

SHOW PROCEDURE STATUS where db = 'Schema_name';

Get specific Procedures of a specific Database Schema in MySQL.

SHOW PROCEDURE STATUS where db = 'sqsapp' and name in ('procedureName1', 'procedureName2', 'procedureNameN');

Functions:

Get the list of all Functions in MySQL.

SHOW FUNCTION STATUS;

Get the list of all Procedures of a specific Database Schema in MySQL.

SHOW FUNCTION STATUS where db = 'Schema_name';

Get specific Procedures of a specific Database Schema in MySQL.

SHOW FUNCTION STATUS where db = 'sqsapp' and name in ('functionName1', 'functionName2', 'functionNameN');