DROP VIEW [HUB.home.views.]viewname;
DROP MATERIALIZED VIEW system.database.schema.viewname;
DROP VIEW "viewname::viewprojection";
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.
- You can also drop a view projection with the ALTER VIEW statement.
DROP VIEW myView1;
DROP MATERIALIZED VIEW ORACLE1.oracle.INVENTORY.custview22
drop view "doctest_view::doctest_projection";