Explore Courses Blog Tutorials Interview Questions
0 votes
in SQL by (119k points)

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;

1 Answer

0 votes
by (55.6k points)

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. 

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Oct 21, 2020 in SQL by dev_sk2311 (45k points)
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

30.5k questions

32.6k answers


108k users

Browse Categories