Answers for "mysql check if index exists and drop"

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

Answers for "mysql check if index exists and drop"

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

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql check if index exists and drop"

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

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us