Home » Bigquery » Tutorials » Drop materialized view

BigQuery Drop materialized view

Deletes a materialized view. The data in the underlying tables are not affected

Drop materialized view example

DROP MATERIALIZED VIEW IF EXISTS mydataset.my_myview

Syntax reference

DROP MATERIALIZED VIEW [IF EXISTS] mv_name