Table of Contents
SHOW PROCEDURES
[NEW in 3.3]
This command is a Valentina extension of SQL standard. It returns the cursor with one record per each existed stored procedure.
Syntax
SHOW PROCEDURES
Result Columns
fld_Procedure
The name of procedure. Type is VarChar.
fld_Create_Procedure
The body of procedure.
Example
SHOW PROCEDURES;
| fld_Procedure | fld_Create_Procedure |
|---|---|
| proc1 | CREATE PROCEDURE proc1 BEGIN ... END |
| proc2 | CREATE PROCEDURE proc2 BEGIN ... END |