我们可以在视图中编写更新和删除查询吗? [英] Can we write update and delete queries in views?

问题描述

在 SQL Server 2005 中，我使用 SELECT 语句创建了一些视图.我们可以在视图中编写 UPDATE 和 DELETE 语句吗?

In SQL Server 2005, I have some views created by using a SELECT statement. Can we write UPDATE and DELETE statements in views?

推荐答案

好吧，如果这是您的要求，您可以从视图中删除，但您不能拥有删除信息的视图.视图是来自基础表的数据的一部分.只要您有权限，您就可以在视图中进行与直接对表进行相同的数据操作.

Well you can delete from a view if that is what you are asking, but you can't have a view that deletes information. The view is a portion of data from the underlying tables. Provided that you have permissions, you can do the same data manipulation in views that you can do to a table directly.

因此您可以执行以下操作:

So you can do something like:

DELETE FROM my_View WHERE id = 3;

何时使用视图
什么是视图

这篇关于我们可以在视图中编写更新和删除查询吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！