In this example, the title “This is the title” defined in table tb is automatically carried over to the view since there were no changes to column b in the view.
CREATE TABLE tb ( a INTEGER, b INTEGER TITLE 'This is the title'); CREATE VIEW vtb AS (SELECT a, b FROM tb); SELECT TITLE (vtb.b);
The SELECT statement produces the following output:
Title(This is the title) --------------------------- This is the title