Home » MCQs » SQL MCQs » SQL Index MCQs

Which statement is correct to remove an Index from MySQL Database?

8. Which statement is correct to remove an Index from MySQL Database?

1. DROP INDEX Index_Name;
2. ALTER TABLE Table_Name DROP INDEX Index_Name;
3. DROP INDEX Index_Name ON Table_Name;
4. DROP INDEX Table_Name.Index_Name;

Answer: B) ALTER TABLE Table_Name DROP INDEX Index_Name;

Explanation:

Correct statement to remove an Index from MySQL Database is - ALTER TABLE Table_Name DROP INDEX Index_Name;