Removes the specified materialized view from the current/specified schema.
ALTER MATERIALIZED VIEW , CREATE MATERIALIZED VIEW , SHOW MATERIALIZED VIEWS , DESCRIBE MATERIALIZED VIEW
DROP MATERIALIZED VIEW [ IF EXISTS ] <view_name>
Copy
Usage notes¶Dropping a materialized view does not update references to that view. For example, if you create a view named “V1” on top of a materialized view, and then you drop the materialized view, the definition of view “V1” will become out of date.
Dropped materialized views can’t be recovered; they must be recreated.
When the IF EXISTS clause is specified and the target object doesn’t exist, the command completes successfully without returning an error.
DROP MATERIALIZED VIEW mv1; ---------------------------+ status | ---------------------------+ MV1 successfully dropped. | ---------------------------+Copy
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4