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
