SQL in a Nutshell

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.