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