17.10 - Example: Creating a Sequenced View on a Temporal Table and Specifying the Valid-Time Column - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Temporal Table Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1182-171K
Language
English (United States)

The following statement creates a similar sequenced view on the Policy table but provides a list of column names that includes the extra column name “Basic_View_Validity”, which the system assigns to the new valid-time column that is appended to the view.

   CREATE VIEW Basic_Auto_Policy_V (
      Policy_ID,
      Customer_ID,
      Basic_View_Validity
      ) AS
   SEQUENCED VALIDTIME
   SELECT Policy_ID, Customer_ID
   FROM Policy
   WHERE Policy_Type = 'AU';