Skip to content

delete-views.md

Latest commit

 

History

History
77 lines (53 loc) · 2.74 KB

delete-views.md

File metadata and controls

77 lines (53 loc) · 2.74 KB
title Delete views
description Delete (drop) views in the Database Engine using SQL Server Management Studio or Transact-SQL.
author WilliamDAssafMSFT
ms.author wiassaf
ms.reviewer randolphwest
ms.date 05/10/2023
ms.service sql
ms.subservice table-view-index
ms.topic how-to
ms.custom
ignite-2025
helpviewer_keywords
dropping views
deleting views
views [SQL Server], deleting
removing views
monikerRange >=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb

Delete views

[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricsqldb]

You can delete (drop) views in the [!INCLUDE ssdenoversion-md] by using [!INCLUDEssManStudioFull] or [!INCLUDEtsql]

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.

Permissions

Requires ALTER permission on SCHEMA or CONTROL permission on OBJECT.

Use SQL Server Management Studio

  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 select Delete.

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

    [!IMPORTANT]
    Select 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.

Use Transact-SQL

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

  2. On the Standard bar, select New Query.

  3. Copy and paste the following example into the query window and select Execute. The example deletes the specified view only if the view already exists.

    USE AdventureWorks2022;
GO

IF OBJECT_ID('HumanResources.EmployeeHireDate', 'V') IS NOT NULL
    DROP VIEW HumanResources.EmployeeHireDate;
GO

    You can also use the IF EXISTS syntax, introduced in [!INCLUDE sssql16-md]:

    USE AdventureWorks2022;
GO

DROP VIEW IF EXISTS HumanResources.EmployeeHireDate;
GO

Next steps