Removing VIEW in SQL Server

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.

Syntax:
DROP VIEW [ IF EXISTS ] [ schema_name . ] view_name [ ; ]

Example:
DROP VIEW vwEmployeeDetails;
DROP VIEW IF EXISTS vwActiveEmployeeDetails;

Hope you find this article helpful.