Stored Procedure issues

New to PHP/MySQL and not very certain of how to work with Stored Procedures.

I am using MAMP and phpMyAdmin. My database name is ‘tshirtshop’.

When I created a stored procedure the only way I can see it in MySQL is to look in the ROUTINES view under the information_schema. (It does not appear in phpMyAdmin under my database.) :confused:

Here are some questions…

1.) Is there a more logical way to see all stored procedures associated with a database?

2.) How do I drop a stored procedure?

I made a type-o, and need to get rid of ‘catalog_get_department_list’ but don’t know how.

I tried…

DROP PROCEDURE catalog_get_department_list;

but that didn’t work.

Sincerely,

TomTees