Mysql statements used to query stored procedures and functions in a database

Method 1:
Select 'name' from mysql. proc where db = 'your _ db_name 'and 'type' = 'Procedure' // Stored PROCEDURE
Select 'name' from mysql. proc where db = 'your _ db_name 'and 'type' = 'function' // FUNCTION
Method 2:
Show procedure status; // Stored procedure

Show procedure status where db = 'servant _ 591up'

Show function status; // function

View the code for creating a stored procedure or function
Show create procedure proc_name;
Show create function func_name;
View
SELECT * from information_schema.VIEWS // View
SELECT * from information_schema.TABLES // table
View triggers
Method 1:
Syntax: show triggers [FROM db_name] [LIKE expr]
Instance: show triggers \ G // trigger
Method 2:
Query the TRIGGERS table in the INFORMATION_SCHEMA Database
Mysql> SELECT * FROM triggers t where trigger_name = "mytrigger" \ G