Postgres Plus Advanced Server Oracle Compatibility Developer's Guide :

Previous PageTable Of ContentsNext Page

3.3.43 DROP VIEW

Name

DROP VIEW -- remove a view

Synopsis

DROP VIEW name

Description

DROP VIEW drops an existing view. To execute this command you must be 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).

Parameters

name

The name (optionally schema-qualified) of the view to remove.

Examples

This command will remove the view called dept_30:

DROP VIEW dept_30;

See Also

CREATE VIEW

Previous PageTable Of ContentsNext Page