Home » MCQs » SQLite MCQs

What is the syntax of SQLite DROP INDEX statement?

92. What is the syntax of SQLite DROP INDEX statement?

1. DELETE INDEX database_name.index_name;
2. DROP INDEX database_name.index_name;
3. DROP INDEX index_name.index_name;
4. DROP INDEX index_name.database_name;

Answer: B) DROP INDEX database_name.index_name;

Explanation:

The syntax of SQLite DROP INDEX statement is:

DROP INDEX database_name.index_name;