Switch to: V9V8V7V6V5

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