Drops an existing view.

Syntax

DROP VIEW [HUB.home.views.]viewname;
DROP MATERIALIZED VIEW system.database.schema.viewname;
DROP VIEW "viewname::viewprojection";

Arguments

  • viewname - name of view.

  • MATERIALIZED - a materialized view is created in a remote datasource. The user must have the DROP TABLE privilege.

  • viewname::viewprojection - a view projection created with ALTER VIEW statement. This statement must be enclosed in double quotation marks.

Additional Information

  • You can also drop a view projection with the ALTER VIEW statement.

Examples

DROP VIEW myView1;
DROP MATERIALIZED VIEW ORACLE1.oracle.INVENTORY.custview22
drop view "doctest_view::doctest_projection";

See Also