视图是对一个或多个表中的数据的一中选择性的展现方式,视图可以包括一个或者多个基本表的几个字段或者全部字段。
可以这样创建一个视图:
a,从不同的基表中整合数据
b,基于其他视图,或者视图与表的结合
c,映射特定数据,因此可以对某些用户屏幕一些数据
来自IBM官网:
A view is an alternative way of representing data that exists in one or more tables. A view can include all or some of the columns from one or more base tables.
You can create a view that:
- Combines data from different base tables
- Is based on other views or on a combination of views and tables
- Omits certain data, thereby shielding some table data from users