DROP VIEW

Drops a view or materialized view within a session.

See also:
[ CREATE ] [ REFRESH ]

---

Syntax

dropViewStatement::=

 

DROP [ MATERIALIZED ] VIEW <viewName>;

---

Examples

Drop a Materialized View

DROP MATERIALIZED VIEW vw_ec2_instance_types;