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