T-SQL » Views » Deleting a View

Syntax:
DROP VIEW view_name, ...
view_name
The name of the view(s) to be removed.

A view can be permanently removed from a database using the DROP command.

Examples

Code:
DROP VIEW vwStudentDetails;
Output:
The command(s) completed successfully.
Explanation:

The view, vwStudentDetails, gets completely removed from the database.

Language(s): MS SQL Server