Cheat Sheet logoCheat Sheet Today
MySQL Procedures, Triggers, and Events Cheatsheet/Show procedure definition

Display the CREATE PROCEDURE statement for an existing routine.

Back to sheetBrowse commands
Sign in to save
Section: stored procedures and functions

Show procedure definition

sql
sql
SHOW CREATE PROCEDURE get_user_by_email\G
Explanation

Great for auditing or exporting routine definitions.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing stored procedures and functions
Change the statement delimiter
Define routines containing semicolons.
OpenIn sheetsqlsame section
Call a stored procedure
Execute a procedure with input arguments.
OpenIn sheetsqlsame section
Create a scalar function
Return a computed value from SQL code.
OpenIn sheetsqlsame section
List stored procedures
Display procedures visible in a schema.
OpenIn sheetsqlsame section
Create a BEFORE INSERT trigger
Normalize row data before insert.
OpenIn sheetsql
List triggers
Display triggers defined in the current schema.
OpenIn sheetsql