You can create constraints on views. The only type of constraint supported on a view is a RELY constraint.This type of constraint is useful when queries typically access views instead of base tables, and the database administrator thus needs to define the data relationships between views rather than tables. View constraints are particularly useful in OLAP environments, where they may enable more sophisticated rewrites for materialized views.
如果你要对物理表进行约束,大可以增加列级check约束,表级constraint约束以及触发器
You can create constraints on views. The only type of constraint supported on a view is a RELY constraint.This type of constraint is useful when queries typically access views instead of base tables, and the database administrator thus needs to define the data relationships between views rather than tables. View constraints are particularly useful in OLAP environments, where they may enable more sophisticated rewrites for materialized views.
所有的约束,或者索引,在定位记录的时候都会用到rowid。这个特性普通视图没有,物理视图可以,因为事实上,每个物理视图背后都有一个物理存在的表支撑。
js/common.js