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.

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

DROP VIEW vwEmployeeDetails;
DROP VIEW IF EXISTS vwActiveEmployeeDetails;

Hope you find this article helpful.

One comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s