Home » MCQs » SQLite MCQs

What is the syntax of DROP VIEW statement?

94. What is the syntax of DROP VIEW statement?

1. DROP VIEW database_name.view_name;
2. DROP VIEW view_name;
3. DROP INDEX database_name;
4. DROP INDEX database_name.view_name;

Answer: D) DROP INDEX database_name.view_name;

Explanation:

The syntax of DROP VIEW statement is:

DROP INDEX database_name.view_name;