Home » MCQs » MariaDB MCQs

What is the correct query syntax to delete an index in MariaDB?

39. What is the correct query syntax to delete an index in MariaDB?

1. DROP index_name;
2. DROP index_name FROM table_name;
3. DROP INDEX index_name FROM table_name;
4. DROP INDEX index_name ON table_name;

Answer: D) DROP INDEX index_name ON table_name;

Explanation:

The correct query syntax to delete an index in MariaDB is:

Syntax:

DROP INDEX index_name ON table_name;