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 have the global SELECT privilege.

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

