List stored procedures

sql

SHOW PROCEDURE STATUS WHERE Db = 'app_db';

Explanation

Useful for inventorying existing routines during maintenance.

Learn the surrounding workflow

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

Same sheet · prioritizing stored procedures and functions

Define routines containing semicolons.

Open In sheetsqlsame section

Execute a procedure with input arguments.

Open In sheetsqlsame section

Return a computed value from SQL code.

Open In sheetsqlsame section

Display the CREATE PROCEDURE statement for an existing routine.

Open In sheetsqlsame section

Normalize row data before insert.

Display triggers defined in the current schema.