Skip to content

delete-views.md

Latest commit

 

History

History
84 lines (56 loc) · 3.2 KB

delete-views.md

File metadata and controls

84 lines (56 loc) · 3.2 KB
title Delete Views | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql
ms.prod_service table-view-index, sql-database, sql-data-warehouse, pdw
ms.reviewer
ms.technology table-view-index
ms.topic conceptual
helpviewer_keywords
dropping views
deleting views
views [SQL Server], deleting
removing views
ms.assetid 6823c7f8-06ca-4bda-8482-7092f03d52a0
author stevestein
ms.author sstein
monikerRange >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

Delete Views

[!INCLUDEtsql-appliesto-ss2008-asdb-asdw-pdw-md] You can delete (drop) views in [!INCLUDEssCurrent] by using [!INCLUDEssManStudioFull] or [!INCLUDEtsql]

In This Topic

Before You Begin

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

Permissions

Requires ALTER permission on SCHEMA or CONTROL permission on OBJECT.

Using SQL Server Management Studio

To delete a view from a database

  1. In Object Explorer, expand the database that contains the view you want to delete, and then expand the Views folder.

  2. Right-click the view you want to delete and click Delete.

  3. In the Delete Object dialog box, click OK.

    [!IMPORTANT]
    Click Show Dependencies in the Delete Object dialog box to open the view_nameDependencies dialog box. This will show all of the objects that depend on the view and all of the objects on which the view depends.

Using Transact-SQL

To delete a view from a database

  1. In Object Explorer, connect to an instance of [!INCLUDEssDE].

  2. On the Standard bar, click New Query.

  3. 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).