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');
Please follow and like us:
