SHOW Statements Comment: To alter or drop stored functions/procedures *************************** 3. row *************************** Privilege: Create Context: Databases,Tables,Indexes Comment: To create new databases and tables *************************** 4. row *************************** Privilege: Create routine Context: Databases Comment: To use CREATE FUNCTION/PROCEDURE *************************** 5. row *************************** Privilege: Create temporary tables Context: Databases Comment: To use CREATE TEMPORARY TABLE ... SHOW PROCEDURE CODE  proc_name mysql>  DELIMITER // mysql>  CREATE PROCEDURE p1 () BEGIN DECLARE fanta INT DEFAULT 55; DROP TABLE t2; LOOP INSERT INTO t3 VALUES (fanta); END LOOP; END// Query OK, 0 rows affected (0.01 sec) mysql>  SHOW PROCEDURE CODE p1// +-----+----------------------------------------+ | Pos | Instruction | +-----+----------------------------------------+ | 0 | set fanta@0 55 | | 1 | stmt 9 "DROP TABLE t2" | | 2 | stmt 5 "INSERT INTO t3 VALUES (fanta)" | | 3 | jump 2 | +-----+----------------------------------------+ 4 rows in set (0.00 sec) mysql>  CREATE FUNCTION test.hello (s CHAR(20)) RETURNS CHAR(50) DETERMINISTIC RETURN CONCAT(’Hello, ’,s,’!’); Query OK, 0 rows affected (0.00 sec) mysql>  SHOW FUNCTION CODE test.hello; +-----+---------------------------------------+ 2940 Privileges belonging to a specific user are displayed by the  SHOW GRANTS  statement. See Section 13.7.7.21, “SHOW GRANTS Statement” , for more information. This statement is a MySQL extension that is available only for servers that have been built with debugging support. It displays a representation of the internal implementation of the named stored procedure. A similar statement,  SHOW FUNCTION CODE , displays information about stored functions (see Section 13.7.7.19, “SHOW FUNCTION CODE Statement” ). To use either statement, you must be the user named as the routine  DEFINER , have the  SHOW_ROUTINE privilege, or have the  SELECT  privilege at the global level. If the named routine is available, each statement produces a result set. Each row in the result set corresponds to one “instruction”  in the routine. The first column is  Pos , which is an ordinal number beginning with 0. The second column is  Instruction , which contains an SQL statement (usually changed from the original source), or a directive which has meaning only to the stored-routine handler. 13.7.7.27 SHOW PROCEDURE CODE Statement