Updatable Views
来源:互联网 发布:visio中数据库图标 编辑:程序博客网 时间:2024/04/30 22:32
MIMIER's Updatable Views
转自:http://developer.mimer.com/documentation/html_92/Mimer_SQL_Engine_DocSet/Data_manipulation6.html
INSERT, UPDATE and DELETE statements may be used on views.
The operation is then performed on the base table upon which the view is defined. However, certain views may not be updated (for example a view containing DISTINCT values, where a single row in the view may represent several rows in the base table).
A view is not updatable if any of the following conditions are true:
- the keyword DISTINCT is used in the view definition
- the select list contains components other than column specifications, or contains more than one specification of the same column
- the FROM clause specifies more than one table reference or refers to a non-updatable view
- the GROUP BY clause is used in the view definition
- the HAVING clause is used in the view definition
Note: By defining an INSTEAD OF trigger any view can be made updatable. If all the INSTEAD OF triggers on the view are dropped, the view will revert to not updatable if one or more of the conditions are true.
SQL Standards Updatable Views
In order to be updatable according to the SQL standard, a view must:
- Have only one table T in its top-level FROM clause
- Not use SELECT DISTINCT in its top-level FROM clause
- Include all attributes from T that do not permit NULLs
- Not refer to T in subqueries
- Not use GROUP BY or aggregation
- Updatable Views
- 关于Views的Updatable问题
- Updatable Join Views【每日一译】--20121202
- Result Set not updatable
- Result Set not updatable解决办法
- insertable = false, updatable = false
- views::RepeatController
- views::Background
- views::Border
- views::LayoutManager
- save views
- ASM Views
- Views framework
- Useful Views
- android views
- materialized views
- Hello views
- PHP views
- win+R 快速启动程序
- BlockingQueue使用
- 15款替代微软产品的开源软件
- android学习笔记28:滚动视图
- 二维数组中的查找
- Updatable Views
- [转]squid vary机制实现详解(附流程图)
- 利用MyEclipse自动创建PO类、hbm文件(映射文件)、DAO
- Struts2学习笔记(14)-----使用ModelDriven接口直接访问对象属性
- 基于评分数据的推荐算法实现:slopeone和矩阵分解
- Mysql Profiling的使用
- VS2008、QT及VTK实现DICOM图像三维重建之三:Win32工程配置
- Java 基础一些代码练习笔记( TreeSet 排序)
- 获得完整路径