O'Reilly logo

SQL in a Nutshell by Kevin Kline

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Name

DROP VIEW

Synopsis

This command permanently removes a view from the current database.

Vendor

Command

SQL Server

Supported

MySQL

Not supported

Oracle

Supported

PostgreSQL

Supported

SQL99 Syntax and Description

DROP VIEW view_name RESTRICT | CASCADE

In the SQL99 syntax, RESTRICT tells the DBMS to prohibit the drop if views or assertions that currently reference the table are to be dropped. The CASCADE clause causes any referencing objects to be dropped along with the view.

This command is not currently supported by MySQL.

Microsoft SQL Server Syntax and Variations

DROP VIEW [owner_name.]view_name [,...n]
GO

Microsoft SQL Server allows multiple views to be dropped in a single command by placing a comma between each view name. The views must reside in the same database. Information about the view is removed from all system tables.

Oracle Syntax and Variations

DROP VIEW [owner_name.]view_name;

As with other Oracle DROP commands, the owner name may be specified along with the view name. Users with the system privilege, DROP ANY VIEW, may drop views owned by other users.

PostgreSQL Syntax and Variations

DROP VIEW view_name;

In PostgreSQL, the DROP VIEW command drops an existing view from the current database. Only the owner of the view may drop it. The PostgreSQL command DROP TABLE also can be used to drops views.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required