Table of Contents Previous Next


3 The SQL Language : 3.3 SQL Commands : 3.3.53 DROP VIEW

3.3.53 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:

3 The SQL Language : 3.3 SQL Commands : 3.3.53 DROP VIEW

Table of Contents Previous Next