Chapter 12 – View Functions

"Be the change that you want to see in the world."

- Mahatma Gandhi

The Fundamentals of Views

View Fundamentals

A view is a virtual table

A view may define a subset of columns

A view can even define a subset of rows if it has a WHERE clause

A view never duplicates data or stores the data separately

Views provide security

View Advantages

An additional level of security is provided

Helps the business user not miss join conditions

Help control read and update privileges

Unaffected when new columns are added to a table

Unaffected when a column is dropped unless its referenced in the view

The above is designed to introduce View fundamentals, View advantages and View recommendations.

Creating a Simple View to Restrict ...

Get Tera-Tom Genius Series - DB2 SQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.