问题描述
我有2个视图，首先创建了View1，然后像
一样创建了View2创建视图View2 AS SELECT * FROM View1
现在，我通过DROP VIEW View1删除View1
我认为View1中的所有数据都已保存到View2中，但看起来并非如此.
当我从View2选择数据时，将发生错误，例如，如果我执行"SELECT * FROM View2"之类的查询，该错误将显示"Microsoft Access数据库引擎找不到输入表或查询"View1" '..."
我不明白，我的查询仅与View2有关，它如何工作?
您能否解释一下，如果可能的话，请给我另一个解决方案，我想在删除View1之前将数据保存在某处?
非常感谢！
I have 2 Views, the View1 is created first, and then View2 is created like as
CREATE VIEW View2 AS SELECT * FROM View1
Now, I drop View1 by DROP VIEW View1
I think all data in View1 has been save into View2, but it doesn''t seem like that.
When I select data from View2, an error will be made, for example, if I execute a query like "SELECT * FROM View2", the error will say "The Microsoft Access database engine cannot find the input table or query ''View1''..."
I don''t understand, my query relates to View2 only, HOW DOES IT WORK?
Could you please explain that, if possible, please give me another solution, I want to save data somewhere before dropping the View1?
Thank you so much!
推荐答案
这篇关于从视图创建视图?怎么了?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！