.png)
Delete Views
You can delete (drop) views in SQL Server 2012 by using SQL Server Management Studio or Transact-SQL
In This Topic
-
Before you begin:
-
To delete a view from a database, using:
Limitations and Restrictions
-
When you drop a view, the definition of the view and other information about the view is deleted from the system catalog. All permissions for the view are also deleted.
-
Any view on a table that is dropped by using DROP TABLE must be dropped explicitly by using DROP VIEW.
Security
To delete a view from a database
-
In Object Explorer, expand the database that contains the view you want to delete, and then expand the Views folder.
-
Right-click the view you want to delete and click Delete.
-
In the Delete Object dialog box, click OK.
Important
Click Show Dependencies in the Delete Object dialog box to open the view_name Dependencies dialog box. This will show all of the objects that depend on the view and all of the objects on which the view depends.
To delete a view from a database
-
In Object Explorer, connect to an instance of Database Engine.
-
On the Standard bar, click New Query.
-
Copy and paste the following example into the query window and click Execute. The example deletes the specified view only if the view already exists.
USE AdventureWorks2012 ; GO IF OBJECT_ID ('HumanResources.EmployeeHireDate', 'V') IS NOT NULL DROP VIEW HumanResources.EmployeeHireDate; GO
For more information, see DROP VIEW (Transact-SQL).
