Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?

Question

A. DROP emp_dept_vu;
B. DELETE emp_dept_vu;
C. REMOVE emp_dept_vu;
D. DROP VIEW emp_dept_vu;
E. DELETE VIEW emp_dept_vu;
F. REMOVE VIEW emp_dept_vu;

Answer 1

The correct answer is option D (DROP VIEW emp_dept_vu). We can use a DROP statement to remove a view from the database. Here is the syntax to remove the view created:

DROP VIEW view_name;

If you are interested in SQL, then sign up for this SQL Certification course by Intellipaat that offers instructor-led training, certification, and job assistance.