1#### suite/funcs_1/storedproc/storedproc_08_show.inc 2# 3# used from .../storedproc_08.inc to show all created / altered routines 4 5--echo 6--echo ... now check what is stored: 7--echo ----------------------------- 8 9--vertical_results 10 11--replace_column 24 <modified> 25 <created> 12SELECT * FROM information_schema.routines where routine_schema = 'db_storedproc'; 13 14 15SHOW CREATE FUNCTION fn_1; 16SHOW CREATE FUNCTION fn_2; 17#SHOW CREATE FUNCTION fn_2b; 18 19SHOW CREATE PROCEDURE sp_1; 20SHOW CREATE PROCEDURE sp_2; 21 22 23--replace_column 5 <modified> 6 <created> 24SHOW FUNCTION STATUS LIKE 'fn_%'; 25 26--replace_column 5 <modified> 6 <created> 27SHOW PROCEDURE STATUS LIKE 'sp_%'; 28 29--horizontal_results 30