Data Type Attributes and Views

Teradata Vantageā„¢ Data Types and Literals

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

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.