Database views are created from one or more base tables or from other views. They are virtual tables that you can use to retrieve data from the underlying views or tables. A view does not contain data so it does not use any space. Only the view definitions are stored in the Data Dictionary.
A view may present only a subset of the columns and rows in the base table or tables. In addition, a column defined in a view can be derived and does not need to exist in the underlying base tables. For example, you can display summed or averaged data in a view column.
Views are generally used to:
To ensure data integrity and system security, Teradata recommends the following:
You can use the following utilities to create views in Teradata:
BTEQ and SQL Assistant allow you to submit CREATE VIEW DDL statements to Teradata Database.