Skip to main content
Shows the content of one or all existing SQL procedures.
SHOW PROCEDURE Syntax

​
Parameters

<schema name>

Name of the schema containing the procedure to show.

<procedure name>

Name of the procedure whose content will be output; use * instead of schema/procedure name to output the DDL of all procedures.

​
Examples

To show the contents of the sqlp_weekly SQL procedure:
SHOW PROCEDURE Example
To output the DDL for all SQL procedures:
SHOW PROCEDURE (All SQL Procedures) Example