drop index if exists mysql
create procedure DeleteIndex() begin IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_NAME = 'TableName' AND INDEX_NAME = 'IndexName' AND INDEX_SCHEMA='DbName') THEN ALTER TABLE TableName DROP index THead2; END IF; END