List of Stored Procedures/Functions Mysql Command

Question

How can I see the list of the stored procedures or stored functions in mysql command line like show tables; or show databases; commands.

Answer 1

As mentioned above,

show procedure status;

Will indeed show a list of procedures, but shows all of them, server-wide.

If you want to see just the ones in a single database, try this:

SHOW PROCEDURE STATUS WHERE Db = 'databasename';

Answer 2

use this:

SHOW PROCEDURE STATUS;

Answer 3

Use the following query for all the procedures:

select * from sysobjects 
where type='p'
order by crdate desc