目录

DROP MATERIALIZED VIEW

用于删除物化视图的 SQL 命令

DROP MATERIALIZED VIEW 是一个用于删除物化视图的 DDL 命令。

DROP MATERIALIZED VIEW 于 PostgreSQL 9.3 中添加。

变更历史

DROP MATERIALIZED VIEW 自从在 PostgreSQL 9.3 中添加以来，未被修改过。

示例

DROP MATERIALIZED VIEW 的基本用法示例

postgres=# DROP MATERIALIZED VIEW bar;
DROP MATERIALIZED VIEW

尝试删除具有依赖关系的物化视图

postgres=# DROP MATERIALIZED VIEW bar;
ERROR:  cannot drop materialized view bar because other objects depend on it
DETAIL:  materialized view bar2 depends on materialized view bar
HINT:  Use DROP ... CASCADE to drop the dependent objects too.

尝试删除不存在的物化视图

postgres=# DROP MATERIALIZED VIEW boo;
ERROR:  materialized view "boo" does not exist

尝试在一个非物化视图的对象上执行 DROP MATERIALIZED VIEW

postgres=# DROP MATERIALIZED VIEW foo;
ERROR:  "foo" is not a materialized view
HINT:  Use DROP TABLE to remove a table.

分类

DDL, SQL 命令

另请参阅

CREATE MATERIALIZED VIEW, ALTER MATERIALIZED VIEW

反馈

请在此处提交任何关于“DROP MATERIALIZED VIEW”的评论、建议或更正。 here。