Example: Overriding the Data Type Attribute Defined in a Base Table

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

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