Question : mysql delete index
Answered by : jason-m-potter
## Deleting indexes is a very simple process:
DROP INDEX indexName ON tableName;
## From Bash/Shell
mysql -e 'DROP INDEX indexName ON tableName;'
Source : https://www.liquidweb.com/kb/mysql-optimization-how-to-leverage-mysql-database-indexing/ | Last Update : Sat, 22 Oct 22
Question : mysql drop index
Answered by : alberto-peripolli
DROP INDEX `PRIMARY` ON t;
Source : https://dev.mysql.com/doc/refman/8.0/en/drop-index.html | Last Update : Wed, 08 Jul 20
Question : drop index if exists mysql
Answered by : sore-serval-4js4gy10a3rc
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
Source : https://stackoverflow.com/questions/39849002/how-to-make-drop-index-if-exists-for-mysql | Last Update : Sat, 28 Aug 21
Question : drop index mysql
Answered by : energetic-emu-5snqv9jpdaca
{"tags":[{"tag":"textarea","content":"DROP INDEX idx_CustomerName ON Customers;\n-- Kindly upvote this answer if it helped you.","code_language":"sql"}]}
Source : | Last Update : Thu, 23 Mar 23