Using a query, a view creates a virtual table whose contents are known. In other terms, a view is a hypothetical table built from a SQL statement’s result set.
A view is made up of a number of named columns and rows of data, similar to a table. It contains fields from one or more actual database tables.
The view can be CREATED, ALTERED, and DROPPED. In this article, you’ll learn how to drop it.
DROP VIEW [ IF EXISTS ] [ schema_name . ] view_name [ ; ]
DROP VIEW vwEmployeeDetails;
DROP VIEW IF EXISTS vwActiveEmployeeDetails;
Hope you find this article helpful.