In this step by step SQL Tutorial I will show you how to use SQL DROP VIEW statement. For the purpose of this tutorial I will use SQL Server Management Studio 2012.
You might find this tutorial if:
- You are new to SQL and DROP VIEW statements
- You would like to find out how to perform DROP VIEW using interface and T-SQL script
- You are preparing for Microsoft Certification and DROP is not what you have used before
SQL DROP View is used to permanently remove view from database.
Below I show you how to remove view from database using SSMS interface and using T-SQL.
In the Object Explorer I open required database in this case it is AdventureWorksDW2012 then I expand views folder and find view which I want to remove. In this example it is vTest view.
To get full access to this page
Become a member or Sign in
Membership is just $3.99/month