Answers for "mysql check if index exists and drop"

SQL
1

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
Posted by: Guest on August-21-2021

Code answers related to "mysql check if index exists and drop"

Code answers related to "SQL"

Browse Popular Code Answers by Language