Code to show procedures in MySQL [closed]

Question

Navigation

#1 by (3 votes)

3

What is the code in MySQL to show the procedures created by me?

mysql sql

asked by anonymous 10.10.2016 / 00:27

1 answer

Varchar or int for "type" fields Doubt on regex

score 3 · Answer 1

I believe this is what you want:

SELECT ROUTINE_TYPE, ROUTINE_NAME
    FROM INFORMATION_SCHEMA.ROUTINES
    WHERE ROUTINE_SCHEMA = 'nome do banco de dados aqui';

You might also want to list:

SHOW PROCEDURE STATUS;

And show the code:

SHOW PROCEDURE CODE;