Chapter 12 – View Functions
"Be the change that you want to see in the world."
- Mahatma Gandhi
The Fundamentals of Views
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
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.