We can view the single procedure using the command SHOW CREATE PROCEDURE proc_name;
To delete the procedure - DROP PROCEDURE proc_name;
To view all the procedures - SHOW PROCEDURE STATUS;