17.05 - Example: Creating a Sequenced View on a Temporal Table and Specifying the Valid-Time Column - Teradata Database

Teradata Vantage™ - Temporal Table Support

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1182-170K

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';