Skip to Main Content
SQL in a Nutshell
book

SQL in a Nutshell

by Kevin Kline
December 2000
Intermediate to advanced content levelIntermediate to advanced
224 pages
9h 52m
English
O'Reilly Media, Inc.
Content preview from 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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SQL in a Nutshell, 3rd Edition

SQL in a Nutshell, 3rd Edition

Kevin Kline

Publisher Resources

ISBN: 1565927443