drop view

Syntax

drop view [owner.]view_name [, [owner.]view_name] ...

view_name – is the name of the view to drop. Specify the owner’s name to drop a view of the same name owned by a different user in the current database. The default value for owner is the current user.

Example 1 – Removes the view new_price from the current database:
```
drop view new_price
```

When you use drop view, the definition of the view and other information about it, including privileges, is deleted from the system tables sysobjects, syscolumns, syscomments, sysdepends, sysprocedures, and sysprotects.
Existence of a view is checked each time the view is referenced, for example, by another view or by a stored procedure.

See also sp_depends, sp_help, sp_helptext in Reference Manual: Procedures.

ANSI SQL – Compliance level: Transact-SQL extension.

The permission checks for drop view differ based on your granular permissions settings.

Setting	Description
Enabled	With granular permissions enabled, you must be the view owner or a user with `drop any view` privilege.
Disabled	With granular permissions disabled, you must be the view owner or a user with sa_role.

Values in event and extrainfo columns of sysaudits are:

Information	Values
Event	33
Audit option	drop
Command or access audited	drop view
Information in `extrainfo`	Roles – current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – NULL