How Views Are Used (176)

Views provide a means to present a different representation of the data that resides
within the base tables. Views are very powerful because they let you tailor the
presentation of data to different types of users. Views are often used to:
■ Provide an additional level of table security by restricting access to a
predetermined set of rows or columns of a table
■ Hide data complexity
■ Simplify statements for the user
■ Present the data in a different perspective from that of the base table
■ Isolate applications from changes in definitions of base tables
■ Express a query that cannot be expressed without using a view
■ Save complex queries

檢視的用途
1. 透過檢視可以設定允許使用者訪問的列和資料行，從而為表提供了額外的安全控制
2. 隱藏資料複雜性
3. 簡化使用者的 SQL 語句
4. 以不同的角度展示基表中的資料
5. 使應用程式不會受基表定義改變的影響
6. 有些查詢必須使用檢視才能正確表達
7. 儲存複雜查詢

[@more@]