How do I view my stored procedures in phpMyAdmin?

Question

I created a stored procedure in phpMyAdmin

CREATE PROCEDURE Sample() SELECT * FROM feedback 

Where could I view this this procedure? If it's not possible in phpMyAdmin, what is/are some good program(s) that have the feature to write, store, and view stored procedures, tables, etc?

Answer 1

View stored procedures in phpmyadmin:

Query:

SELECT routine_definition FROM information_schema.routines WHERE  routine_name = 'procedure_name' AND routine_schema = 'databasename'; 

Here's how to get there in phpmyadmin.

The routines option is available in phpmyadmin. The link is not visible in PHPmyadmin until you have at least one stored procedure. See the above image and click the routines link under structure tab.

Answer 2

select routine_definition from information_schema.routines where routine_schema = 'db_name' and routine_name = 'sp_name';