Skip to main content

DROP VIEW

Drops a view or materialized view within a session.

See also:
[ CREATE ] [ REFRESH ]

Syntax​

dropViewStatement::=

DROPMATERIALIZEDVIEWviewName';'

 
 

DROP [ MATERIALIZED ] VIEW <viewName>;

Examples​

Drop a Materialized View​

DROP MATERIALIZED VIEW vw_ec2_instance_types;