SQL - SP - drop_index_if_exists

DELIMITER $$
CREATE PROCEDURE `drop_index_if_exists`(IN `theTable` VARCHAR(128) CHARSET utf8, IN `theIndexName` VARCHAR(128) CHARSET utf8) NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER BEGIN
    IF((SELECT COUNT(*) AS index_exists FROM information_schema.statistics WHERE TABLE_SCHEMA = DATABASE() and table_name =
    theTable AND index_name = theIndexName) > 0) THEN
   SET @s = CONCAT('DROP INDEX `' , theIndexName , '` ON `' , theTable, '`');
   PREPARE stmt FROM @s;
   EXECUTE stmt;
 END IF;
END$$
DELIMITER ;

-- PROCEDURE TO THAT DROPS INDEX IF THE EXIST
-- USAGE: CALL drop_index_if_exists('TABLE_NAME','INDEX_NAME');
-- MySql