如果表被删除，现有的DB2视图会发生什么？ [英] What happens to an existing DB2 view, if the table is dropped?

问题描述

如果我们在现有的DB2表上创建了一个视图，然后删除该表。视图会发生什么？

If we have created a view on an existing DB2 table and then drop the table. What will happen to the view ?

推荐答案

视图无效/无效。尝试从中选择它将失败。

The view becomes invalid/inoperative. Attempts to select from it will fail.

尝试：

create table TEST_TABLE (
TEST_COL INTEGER
);

INSERT INTO TEST_TABLE VALUES(1);

SELECT * FROM TEST_TABLE;

create view TEST_VIEW AS
SELECT * FROM TEST_TABLE;

SELECT * FROM TEST_VIEW;

DROP TABLE TEST_TABLE;

SELECT * FROM TEST_VIEW;

最后一个语句给出错误：

The last statement gives the error:

[IBM][CLI Driver][DB2/NT] SQL0575N  View or materialized query table
"TEST_VIEW" cannot be used because it has been marked inoperative.
SQLSTATE=51024

这篇关于如果表被删除，现有的DB2视图会发生什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！