Data Type Attributes and Views | Data Types and Literals | Teradata Vantage - 17.10 - Data Type Attributes and Views - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

When defining a view, any expression in the SELECT expression list can include a data definition. The data type attributes determine the form of the view display. The data type attributes for a view column can differ from those defined for the associated column of the underlying base tables or views. However, not all data definitions are relevant to view expressions.

If you define data type attributes for a view column, these attributes will override any data type attributes defined for the associated column of the underlying base tables or views. For example, a TITLE phrase in the CREATE VIEW statement will override a TITLE phrase in the CREATE TABLE statement of the underlying table.

Any data type attributes defined for a column in the underlying base tables or views are carried over to the view only if the associated view column is not modified in any way.