17.10 - Example: Overriding the Data Type Attribute Defined in a Base Table - 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)

In this example, the vtb2 view is created from table tb in example 1. The view definition changes the name of column b to c. Therefore, the title “This is the title” defined in table tb is not carried over to the view.

CREATE VIEW vtb2 AS
(SELECT a, b AS c
 FROM tb);

SELECT TITLE(vtb2.c);

The SELECT statement produces the following output:

Title(c)
-----------
c