Les comparto la forma de realizar la consulta en la versión 8.0
SELECT routine_name FROM information_schema.routines WHERE routine_schema = database() and routine_type = ‘PROCEDURE’;
Examen
Examen final del curso
9 comentario(s)
Les comparto la forma de realizar la consulta en la versión 8.0
SELECT routine_name FROM information_schema.routines WHERE routine_schema = database() and routine_type = ‘PROCEDURE’;
SHOW PROCEDURE STATUS WHERE db = database() AND type = 'PROCEDURE'\G
SELECT ROUTINE_SCHEMA, ROUTINE_NAME FROM information_schema.routines;
Clase 70