MySQL 5.1 Reference Manual :: 13 SQL Statement Syntax :: 13.5 Database Administration Statements :: 13.5.4 SHOW Syntax :: 13.5.4.8 SHOW CREATE PROCEDURE and SHOW CREATE
FUNCTION Syntax
Section Navigation [Toggle]
- 13.5.4 SHOW Syntax
- 13.5.4.1 SHOW AUTHORS Syntax
- 13.5.4.2 SHOW CHARACTER SET Syntax
- 13.5.4.3 SHOW COLLATION Syntax
- 13.5.4.4 SHOW COLUMNS Syntax
- 13.5.4.5 SHOW CONTRIBUTORS Syntax
- 13.5.4.6 SHOW CREATE DATABASE Syntax
- 13.5.4.7 SHOW CREATE EVENT
- 13.5.4.8 SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION Syntax
- 13.5.4.9 SHOW CREATE TABLE Syntax
- 13.5.4.10 SHOW CREATE VIEW Syntax
- 13.5.4.11 SHOW DATABASES Syntax
- 13.5.4.12 SHOW ENGINE Syntax
- 13.5.4.13 SHOW ENGINES Syntax
- 13.5.4.14 SHOW ERRORS Syntax
- 13.5.4.15 SHOW EVENTS
- 13.5.4.16 SHOW GRANTS Syntax
- 13.5.4.17 SHOW INDEX Syntax
- 13.5.4.18 SHOW INNODB STATUS Syntax
- 13.5.4.19 SHOW OPEN TABLES Syntax
- 13.5.4.20 SHOW PLUGINS Syntax
- 13.5.4.21 SHOW PRIVILEGES Syntax
- 13.5.4.22 SHOW PROCEDURE CODE and SHOW FUNCTION CODE Syntax
- 13.5.4.23 SHOW PROCEDURE STATUS and SHOW FUNCTION STATUS Syntax
- 13.5.4.24 SHOW PROCESSLIST Syntax
- 13.5.4.25 SHOW SCHEDULER STATUS Syntax
- 13.5.4.26 SHOW STATUS Syntax
- 13.5.4.27 SHOW TABLE STATUS Syntax
- 13.5.4.28 SHOW TABLES Syntax
- 13.5.4.29 SHOW TRIGGERS Syntax
- 13.5.4.30 SHOW VARIABLES Syntax
- 13.5.4.31 SHOW WARNINGS Syntax
SHOW CREATE {PROCEDURE | FUNCTION} sp_name
These statements are MySQL extensions. Similar to
SHOW CREATE TABLE, they return the exact
string that can be used to re-create the named routine. The
statements require that you be the owner of the routine or
have SELECT access to the
mysql.proc table.
mysql> SHOW CREATE FUNCTION test.hello\G
*************************** 1. row ***************************
Function: hello
sql_mode:
Create Function: CREATE FUNCTION `test`.`hello`(s CHAR(20)) »
RETURNS CHAR(50)
RETURN CONCAT('Hello, ',s,'!')
User Comments
Add your own comment.