Syntax:
SHOW CREATE PROCEDURE proc_name

This statement is a MySQL extension. It returns the exact string that
can be used to re-create the named stored procedure. A similar
statement, SHOW CREATE FUNCTION, displays information about stored
functions (see [HELP SHOW CREATE FUNCTION]).

To use either statement, you must be the user named as the routine
DEFINER, have the SHOW_ROUTINE privilege, have the SELECT privilege at
the global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE
privilege granted at a scope that includes the routine. The value
displayed for the Create Procedure or Create Function field is NULL if
you have only CREATE ROUTINE, ALTER ROUTINE, or EXECUTE.

URL: https://dev.mysql.com/doc/refman/8.0/en/show-create-procedure.html

