Answers for "mysql drop index if exists"

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 drop index if exists"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql drop index if exists"

Code answers related to "mysql drop index if exists"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql drop index if exists"

Code answers related to "mysql drop index if exists"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us