O'Reilly logo

V14 Certification: Teradata SQL by Tom Coffing, Leona Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 14 – 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

View definitions are stored in the Data Dictionary, not the user’s space 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.

View Recommendations

Only utilities, such as FastLoad, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required