Example: Overriding the Data Type Attribute Defined in a Base Table - Teradata Vantage - Analytics Database

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