Postgresql 中文操作指南
DROP MATERIALIZED VIEW
DROP MATERIALIZED VIEW — 删除物化视图
DROP MATERIALIZED VIEW — remove a materialized view
Description
DROP MATERIALIZED VIEW 删除现有物化视图。要执行此命令，您必须是物化视图的所有者。
DROP MATERIALIZED VIEW drops an existing materialized view. To execute this command you must be the owner of the materialized view.
Parameters
-
IF EXISTS
-
Do not throw an error if the materialized view does not exist. A notice is issued in this case.
-
-
name
-
The name (optionally schema-qualified) of the materialized view to remove.
-
-
CASCADE
-
Automatically drop objects that depend on the materialized view (such as other materialized views, or regular views), and in turn all objects that depend on those objects (see Section 5.14).
-
-
RESTRICT
-
Refuse to drop the materialized view if any objects depend on it. This is the default.
-
Examples
此命令将删除名为 order_summary 的物化视图：
This command will remove the materialized view called order_summary:
DROP MATERIALIZED VIEW order_summary;