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