mysql> SHOW FUNCTION STATUS     -> // +-------+----------+----------------+---------------------+---------------------+---------------+---------+ | Name  | Type     | Definer        | Modified            | Created             | Security_type | Comment | +-------+----------+----------------+---------------------+---------------------+---------------+---------+ | hello | FUNCTION | root@localhost | 0000-00-00 00:00:00 | 2004-03-27 15:43:57 | DEFINER       |         | +-------+----------+----------------+---------------------+---------------------+---------------+---------+ 1 row in set (0.00 sec) mysql> DROP PROCEDURE simpleproc1     -> // Query OK, 0 rows affected (0.00 sec)