Database Fundamentals — Question 67

You need to remove a view named EmployeeView from your database.
Which statement should you use?

Answer options

• A. DELETE VIEW EmployeeView
• B. DELETE EmployeeView
• C. DROP EmployeeView
• D. DROP VIEW EmployeeView

Correct answer: D

Explanation

The correct command to remove a view in SQL is 'DROP VIEW', which is why option D is correct. Option A is incorrect as 'DELETE VIEW' is not a valid SQL command. Option B is also wrong because 'DELETE' is used for removing records from a table, not a view. Option C lacks the 'VIEW' keyword, making it an invalid command.