CODE EXAMPLE FOR SQL

show procedures mysql

show procedure status where db = 'my_database';