select
routine_name 
from information_schema.routines
where routine_catalog = 'YourDBName'
and routine_schema = 'YourSchemaName'
order by routine_name;