Table of Contents Previous Next


2 The SQL Language : 2.3 SQL Commands : 2.3.59 DROP VIEW

2.3.59 DROP VIEW
DROP VIEW -- remove a view
DROP VIEW drops an existing view. To execute this command you must be a database superuser or the owner of the view. The named view will not be deleted if other objects are dependent upon this view (such as a view of a view).
The form of the DROP VIEW command compatible with Oracle does not support a CASCADE clause; to drop a view and it's dependencies, use the PostgreSQL-compatible form of the DROP VIEW command. For more information, see the PostgreSQL core documentation at:

2 The SQL Language : 2.3 SQL Commands : 2.3.59 DROP VIEW

Table of Contents Previous Next